Incrementing value in a cell depending on clicking of a macro button

[Decatron]

Hi

I want a cell "b9" to get incremented by 1 automatically whenever the macro "SaveFile" is being clicked. Please help me by suggesting an appropriate code snippet for the above query

Thanks!

[georgiboy]

Welcome to the forum,

Maybe add the below line to your SaveFile macro:


Range("B9") = Range("B9") +1
Or

Sheet1.Range("B9") = Sheet1.Range("B9") + 1
Or

Sheets("Sheet1").Range("B9") = Sheets("Sheet1").Range("B9") + 1

[Decatron]

Welcome to the forum,

Maybe add the below line to your SaveFile macro:


Range("B9") = Range("B9") +1
Or

Sheet1.Range("B9") = Sheet1.Range("B9") + 1
Or

Sheets("Sheet1").Range("B9") = Sheets("Sheet1").Range("B9") + 1

[Decatron]

Thanks for the help. It worked.