Create Range from Range

  • Thread starter Thread starter dksaluki
  • Start date Start date
D

dksaluki

Excel VBA:
Let's say I have a range object set to be from B2:F6, and i need to
make another range object to be the last row of my original range.
(New range to be B6:F6) How would i go about doing this? I tried
the .Resize option, but that only works from the top left cell of a
range.

DK
 
Another method:

Dim Rng1 as range
Dim Rng2 as range

set rng1 = activesheet.range("b2:F6")
set rng2 = rng1.rows(rng1.rows.count)

or
with rng1
set rng2 = .rows(.rows.count)
end with
 
Back
Top