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
|