I have a range of cells that I need to check if they are empty or 0.
The cells contain a formula "=TRANSPOSE(''A2:JK8)"
As a result, any time I try to check the cell value or modify the cell value I seem to get "type mismatch" errors.
If Range("A2:JK8").value = "" Then
Can anybody help me get around this?
I attempted to convert the cell to a value (and remove the formula) but I got an error "cannot change part of an array".
Range("A2:JK8").value = Range("A2:JK8").value