check if the result of a formula is null
in cell A1, I have a formula:
=IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time
Line'!a"&ROW()))
How would I check for this condition in code?
I'd tried using:
if len(Range("A1") = 0 then... but it seems to evaluate the actual cell
contents, not the result of the formula in the cell (consequently, the
condition always checks TRUE)
thanks in advance,
mark
|