If Range("A10").value = 10 then
Range("A12").value = "Good"
Else
Range("A12").value = "Bad"
End If

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"dave caizley" wrote:

I'm fairly new to Macros so this may seem very simple to you.

I basically want to run a nested statement
if A10="Yes" then type "Good" in cell A12, if A10="No" then type "Bad" in
A12 else a blank cell.

I know I can do it as a formula but I would prefer this to be incorporated
into an existing macro.

Thanks in anticipation