add and remove rows from a called range

  • Thread starter Thread starter Buddy Lee
  • Start date Start date
B

Buddy Lee

I have a range A1:D3 called "range" and I need to add rows to this range
( A1:D3 => A1:D4 => A1:D5)
and I need to remove them too. How should I do this?

Thank you
 
set rng = Range("A1:D3")
rng.rows(rng.rows.count).Insert shift:=xlShiftDown
? rng.Address
$A$1:$D$4

if you mean a named range
set rng = Range("A1:D3")
rng.name = "Range"
? Range("Range").Address
$A$1:$D$3
Range("Range").Rows(Range("Range").Rows.Count).Insert Shift:=xlShiftDown
? rng.Address
$A$1:$D$4
? Range("Range").Address
$A$1:$D$4
 
Maybe I missed it, but what about removing rows? From the range object only,
and not from the worksheet as well as Range.Delete would do?

Thanks,

Anton
 
Back
Top