Creating Non-Contiguous Cell Ranges

[marsto...@mac.com]

Can someone explain how you take specific cells from a parent range
and create a non-contiguous child range that uses some of the cells
from the parent range?

[Tom Ogilvy]

set rng = Range("A1,A3,A5,A7")

rng.Name = "Child1"

or
set rng = Range("A1")
for i = 3 to 11 step 2
set rng = union(rng,cells(i,1))
Next
rng.Name = "Child1"

any method would depend on how you are choosing/identifying the subset.

--
Regards,
Tom Ogilvy

"marsto...@alaskaair.com" <marsto...@mac.com> wrote in message
news:chg5i5$a...@odak26.prod.google.com...

[marsto...@mac.com]

Thanks Tom - I think I have enough now to see if I can make things
work. I'm heading in to work tomorrow - no time off for me
unfortunately..... I'll let you know.