Declare Worksheet name over multiple modules
Hi
Is it possible to declare the worksheets name once and use it over multiple
modules.
ie
Dim wksCurrent as worksheet
Set wksCurrent = worksheets("Test")
Once the above is done I want to be able to use the wksCurrent in all of the
modules I have available.
Any ideas would be great.
Thanks
|