In my code I have a lot of references to Worksheets. Is it possible to declare the object references once at the module level?
In my code I have a lot of references to Worksheets. Is it possible to declare the object references once at the module level?
Reality is stranger than fiction.
You need to explain better and provide some examples.
Ben Van Johnson
Fair. I know that the following code is giving me an error but I want to know where I'm going wrong.
Essentially I'm trying define these Object References once and have them accessible as such anywhere within my VBA code.![]()
Please Login or Register to view this content.
you can declare them but you can't assign them there. much easier to just use the codename when referring to the sheets in your code (it acts as a variable)
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks