Selecting multiple ranges
I want to select multiple contiguous row ranges in non-contiguous columns but can't seem
to figure it out.
The macro recorder equivalent is
Range("U2:U12,Y2:Y12").Select
This is an abbreviation of what I want as I'm trying to select five ranges in all.
From the VBA "Help" it appears as if I'd have to use "Union", is there another way (or
I'll have a statement that will go on forever!)?
--
Regards;
Rob
------------------------------------------------------------------------
|