mhdi
asked on
VBA Excel - Error checking cell value on cells containing TRANSPOSE forumla
Hi,
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.
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".
Thankyou
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
Thankyou
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.