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

if cell.offset(0,7).value ="" AND cell.offset(0,7).value =0 THEN
...........................

"leonidas" wrote:


Hi,

In the "worksheet_activate" code of a worksheet(1) I have a little
problem.
I have a formula on the worksheet(1) which refers to a cell on another
worksheet(2) and when the cell with the formula(1) contains no value
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't
matter which of the two it is, the code will allways work?
Thanks in advance for any help!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=574115