set range
 

make sure that you have
OPTION EXPLICIT
at the top of your module

then
DIM MyRangeOne as Range
DIM MyRangeTwo as Range

SET MyRangeOne = Worksheets("sheet2").Range("Z12:AG12")
SET MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500")


"Excel User" wrote in message
...
Hi,

I keep getting an error with the following:

MyRangeOne = Worksheets("sheet2").Range("Z12:AG12")
MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500")

Is this not the way to set a range?

Thanks

set range
 

Patrick,

Thanks for your reply, I'm picking up someone's script, it seems that
MyRangeOne & MyRangeTwo are set as DIM MyRangeOne as String.

Thanks!

"Patrick Molloy" wrote in message
...
make sure that you have
OPTION EXPLICIT
at the top of your module

then
DIM MyRangeOne as Range
DIM MyRangeTwo as Range

SET MyRangeOne = Worksheets("sheet2").Range("Z12:AG12")
SET MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500")


"Excel User" wrote in message
...
Hi,

I keep getting an error with the following:

MyRangeOne = Worksheets("sheet2").Range("Z12:AG12")
MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500")

Is this not the way to set a range?

Thanks