Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Non-Contiguous Cell Ranges
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Non-Contiguous Cell Ranges
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 " wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
summing non contiguous ranges | Excel Discussion (Misc queries) | |||
Adding Non-Contiguous Ranges | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Creating an array from non-contiguous ranges | Excel Programming |