Public worksheet

[prlondhe]

Hi

i have 3 different worksheets used during different modules. Is there a way that i can set these worksheets as public variables and then refer to them in the modules.

Public ws1 as string
public ws2 as string
public ws3 as string

sub setvar()
set ws1=sheet(1)
set ws2=sheet(2)
set ws3=sheet(3)
end sub

 

[AlphaFrog]

[COLOR=darkblue]Public[/COLOR] ws1 [COLOR=darkblue]As[/COLOR] [B]Worksheet[/B]
[COLOR=darkblue]Public[/COLOR] ws2 [COLOR=darkblue]As[/COLOR] [B]Worksheet[/B]
[COLOR=darkblue]Public[/COLOR] ws3 [COLOR=darkblue]As[/COLOR] [B]Worksheet[/B]


[COLOR=darkblue]Sub[/COLOR] setvar()
[COLOR=darkblue]Set[/COLOR] ws1 = [B]Sheets[/B](1)
[COLOR=darkblue]Set[/COLOR] ws2 = [B]Sheets[/B](2)
[COLOR=darkblue]Set[/COLOR] ws3 = [B]Sheets[/B](3)
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]