Giving a worksheet a name

[Rebuild8]

I have a With statement that applies to a certain sheet. However, within that With are several references to another sheet. Is there a way I can name the second sheet? I tried

Nov = Worksheets("November")

but it gave an error. What I want to do is be able to make a statement like this

Nov.Range("A1").Copy

 

[Misca]

Try

Worksheets("November").Range("A1").Copy

Or if you need to set it as a variable try

Set Nov = Worksheets("November")

 

[Rebuild8]

"Set" did it! THANKS!!

 

[Saagar]

Try set Nov = Worksheets("November")