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