Monday, April 16, 2007
To use a counter in your macro, just assign any cell to retain the value. In this example the cell A1 is chosen. Each time the macro is run, it adds the value 1 to the cell A1.
mycount = Range("a1") + 1
Range("a1") = mycount
Posted by Ayush Jain at 7:14 AM