This did the trick; thanks for the help

"Gary''s Student" wrote:

If Range("mend_tape_cnt").Value 0 then
--
Gary''s Student - gsnu200808


"El Bee" wrote:

I have a macro that needs to check the value of a cell in a different
worksheet. The cell has a defined name called "mend_tape_cnt". How can I
write a formula within the macro to perform an "IF" statement against this
cell value.
For example:
If "mend_tape_cnt" 0 then
......
else
......
End If

thanks for the help,

El Bee