network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 8 months |
| seen | Oct 13 '12 at 7:45 | |
| stats | profile views | 2 |
|
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 |
