Declare Worksheet name over multiple modules

[Guest]

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

 

[NickHK]

Yes, if the Dim statement is in a normal module.

NickHK

 

[Guest]

Hi Nick
Can you please elaberate on Normal Module???

Do you mean attached to a sheet or an actual module

If an actual module what do I put up the top of the module

Thanks

 

[NickHK]

Yes, insert a module and declare the top.
Not on a WS or class module

NickHK