Macro formula help

[El Bee]

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

 

[Don Guillett]

If range("mend_tape_cnt") > 0 then

 

[Bernard Liengme]

Use
If Range("mend_tape_cnt") > 0 then

best wishes

 

[El Bee]

This works fine when entering the formula within a cell but I trying to
figure out how to write the formula within a macro so that if the
"mend_tape_cnt" is greater than zero do whaterver else do something else.

 

[Gary''s Student]

If Range("mend_tape_cnt").Value > 0 then

 

[El Bee]

This did the trick; thanks for the help

If Range("mend_tape_cnt").Value > 0 then