LinkBack URL
About LinkBacks
Rick-O-Shay 
Is there a way to make a VBA code where everytime I run this macro it adds 1 to a cell and keeps a running total?
Example:
E17 currently = 0
Running the macro makes it display 1
Running it again makes it display 2 etc...
Is there a way to make a VBA code where everytime I run this macro it adds 1 to a cell and keeps a running total?
Example:
E17 currently = 0
Running the macro makes it display 1
Running it again makes it display 2 etc...
Last edited by Rick-O-Shay; 12-30-2009 at 02:47 PM. Reason: Solved
There is probably a better way than the code below.
Add this line to your macro.
Change the sheet reference to suit your needs.
Sheet1.Range("E17").Value = Sheet1.Range("E17").Value + 1
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks