How about this

Set My_Multiple_Range = Union(Range("a1:a3"),Range("a7:a9"))
--
HTH,
Barb Reinhardt



"John" wrote:

How can you represent this in cell notation so you can use variables?

Set My_Multiple_Range = Range("a1:a3,a7:a9")

thanks
John