check if the result of a formula is null

[mark kubicki]

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

 

[Guest]

if len(Range("A1").Value)=0 then

 

[mark kubicki]

actually.. that's what I meant to type in this post (.value...)
unless i'm missing something else...it checks the cells contents and notes
the formula in the cell as having length; versus the length of the result of
the formula

-mark

 

[mark kubicki]

nevermind... got it, thanks

actually.. that's what I meant to type in this post (.value...)
unless i'm missing something else...it checks the cells contents and notes
the formula in the cell as having length; versus the length of the result
of the formula

-mark