Macros in excel

[Guest]

How do i edit a macro like: if cell F20=0 then cell G5=3 ?

 

[JulieD]

Hi

something along the lines of

sub test1()
If Range("F20") = 0 Then Range("G5").value = 3
End sub


Cheers
JulieD