Say I am using the following in the first macro. Once the macro is completed, I use a 2nd macro to clear the fields on the spreadsheet to reuse it using the first macro. Is there a way to clear out the variables globally so that macro can run cleanly? Without using each of the variable names (as they vary from sheet to sheet) since the 2nd macro clears out many other spreadsheets?
Please Login or Register to view this content.
Where are these variables declared?
If posting code please use code tags, see here.
These variables are defined in the first macro. Separate spreadsheets will have different variables.
The 2nd macro that resets the spreadsheets is an add-in. This is where I want to clear the variables from the various spreadsheets.
If these variables have been declared within a sub then they aren't visible to any other subs.
Maybe I am asking the wrong question. When the variables are declared Excel sets aside memory. Is there a way to globally clear out the memory?
That memory is released as soon as the sub ends.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks