if range("a2")0 then sheets("sheet1").range("a2").value="x"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DR" wrote in message
...
I am relatively new to macros and only know how to record a macro. I am
trying to use an if formula in a macro but am not sure how. What I need
it
to do is if a value is = 0 then populate certain fields on a particular
worksheet, and if a particular value is greater than zero then populate
certain cells on a different worksheet. If there is no value then do
nothing.

Please help,

DR