alternative for =0 and =""

[leonidas]

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

 

[Guest]

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