When I create macros, I like to create many small macros rather than one large one. The problem, however, is that I have to define my variables over and over in each small macro. Is there a way that I can have a macro that defines my variables to be used in all other macros within the workbook?
yes, define variable before all subs
dim myvar as string sub a() ----- end sub sub b() ----- end sub
If solved remember to mark Thread as solved
Hi Jiptastic
See this link
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks