Hi,

In the "worksheet_activate" code of a worksheet(1) I have a littl
problem.
I have a formula on the worksheet(1) which refers to a cell on anothe
worksheet(2) and when the cell with the formula(1) contains no valu
sometimes the code
if cell.offset(0,7).value ="" works,
and sometimes the code
if cell.offset(0,7).value =0 works.
Is there some way to combine these two (=0 and ="") so that it doesn'
matter which of the two it is, the code will allways work?
Thanks in advance for any help

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=57411