Creating Non-Contiguous Cell Ranges

  • Thread starter Thread starter marston.gould
  • Start date Start date
M

marston.gould

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?
 
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.
 
Back
Top