View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Set Sheets as variable

I am trying to set two sheets as variables and it is not working how I
thought it should.

I have declared them like this

Dim Sht As Worksheet
Dim Env As Worksheets
And tried to set them like this.
Set Sht = Sheet1
Set Env = Sheet2
It errors out on the Set Env line. I am not sure how to make this
right. I would prefer sot to have to use Sheet2 for evey place in my
code that I have Env.

Thanks,
Jay