Set Sheets as variable

[jlclyde]

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

 

[jlclyde]

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

My bad. I have one as sheet and the other as sheets.
Sorry,
Jay

 

[Dave Peterson]

Instead of using variables that represent those sheets, you could just change
the codename to what you want.

Open your workbook
Go into the VBE
Select your project
select the worksheet object
Hit F4 to see the project explorer
Change the (Name) property (with the ()'s) to what you want.

Then drop the dim statements completely.