Joanne

Unregistered less info
6 reputation
1
bio website
location
age
visits member for 1 year, 10 months
seen Oct 13 '12 at 7:45

Sep
26
comment Resetting a macro counter to 0
This is my code: Private codeRun As Boolean Public Sub CountMacro() If codeRun Then Exit Sub End If codeRun = True so basically this particular macro can only be used once during the week. At the end of the week, the workbook is cleaned of it's data (this is a balance sheet so I need the closing data to be used as opening data each week) and reused the following week. However, since this macro has now been deactivated, it does not work. I need to create another macro that when the workbook is cleaned, it also resets the counter for Public Sub CountMacro() to zero so that I can reuse it.
Sep
24
comment Resetting a macro counter to 0
Thank you Spike and Peter. I will try that and see if that works.
Sep
23
awarded  Student
Sep
23
asked Resetting a macro counter to 0