Using a variable name in a Range Select

I am working on a sheet that will change the range for certain cells each time a new week rolls around. Therefore I want to enter in a variable name fore the cells to select rather than coded range.

I.E.

Rather than

Please Login or Register  to view this content.

I want to use

Please Login or Register  to view this content.

I am using a 52 statement CASE statement to assign the Var1 values, again I.E.

Please Login or Register  to view this content.

I have tried a few different methods to get this simple range select to work with a variable name with no luck at all. in the example above the code runs, but does not select anything at all, and in the example below I get a Method 'Range' of pbject_Global' failed, runtime error 1004

Any assistance on this would be greatly appreciated.

Thank You

Range(var1).select

?

Try removing the quotes around var1.

This did it!! I could have sworn I tired this without the quotes when I first put the variables in. I must have missed something somewhere. Thank you much, sometimes it just takes another pair of eyes!!