Sometimes it is useful to know how many times a macro has been run. For example, if you run a macro once a week to perform a particular task, but don’t want it run more than once a week, having a counter might be helpful.
Copy all of the code below. Paste it into your workbook’s Visual Basic editor, either under a Microsoft Excel Object or Module. You can also add other macro commands after the “Range(“A1″) = macrocount” line. This will allow you to count how many times those macro commands have been run.
Need help? Use our nifty guide to help figure out how to install and use your macros.