View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noemi Noemi is offline
external usenet poster
 
Posts: 74
Default 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