you can try this:

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

--


Gary


"John" wrote in message
...
How can you represent this in cell notation so you can use variables?

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

thanks
John