Obect Required error when variable already set earlier in sub?

Hey folks! I have what I hope is an easy question to answer.

So I have code where I'm setting the following variables:

Please Login or Register  to view this content.

For the first few lines, whenever I call on w1.Copy, it works great.

However, if I have code later in the sub that looks like this:

Please Login or Register  to view this content.

I get an Object Required error in the debugger. Do I have to set w1-w5 every time even though the range never changes? I'm thinking it has something to do with the fact that I'm re-setting z to refer to a new worksheet, but I figured since I'm re-setting z I wouldn't need to reset the w's as well since those just call on the most recent z variable.

But I'm also learning VBA as I go, so I know I'm using flawed logic here (if for no other reason than it isn't working :P). Is anyone able to let me know where I'm going wrong here, whether it be syntax or thinking?

Thanks!

Originally Posted by mrbusto71

Do I have to set w1-w5 every time even though the range never changes?

Yes. When you define a Range variable like you do with W1-W5, the range includes it's actual parent sheet and actual parent workbook. The range variable doesn't reference the variables (x and z) that were used when it was defined.

Alternatively, you could use this syntax to define the range variables...

Please Login or Register  to view this content.