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!
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!
Last edited by Decatron; 07-04-2023 at 11:51 PM.
Welcome to the forum,
Maybe add the below line to your SaveFile macro:
OrRange("B9") = Range("B9") +1
OrSheet1.Range("B9") = Sheet1.Range("B9") + 1
Sheets("Sheet1").Range("B9") = Sheets("Sheet1").Range("B9") + 1
Thanks for the help. It worked.