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

If range("mend_tape_cnt") 0 then


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"El Bee" wrote in message
...
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

Use
If Range("mend_tape_cnt") 0 then

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"El Bee" wrote in message
...
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

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.

"Don Guillett" wrote:

If range("mend_tape_cnt") 0 then


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"El Bee" wrote in message
...
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

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

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