On Dec 3, 10:57*am, jlclyde wrote:
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