Defining cell range as a variable

[jay567]

Hi,

Stupid question here... how would I define a cell range as a variable?

For example

x = range("a1:a5")

x.select

How would I make this work?

Thanks for your help.

J

[richardreye]

Close, try this

Set x = Range("A1:A5")

x.Select

Cheers!