View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark kubicki mark kubicki is offline
external usenet poster
 
Posts: 32
Default 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