ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros in excel (https://www.excelbanter.com/excel-programming/324226-macros-excel.html)

Panagiotis

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

JulieD

Macros in excel
 
Hi

something along the lines of

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


Cheers
JulieD


"Panagiotis" wrote in message
...
How do i edit a macro like: if cell F20=0 then cell G5=3 ?





All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com