Wednesday, March 19, 2014

Excel VBA - How To Insert Rows

Inserting a Row at at Row 2
Range("A2").EntireRow.Insert

'Inserting 3 Rows from 3
Rows("3:5").EntireRow.Insert

Inserting from row 1
ws.Rows(1).Insert shift:=xlShiftDown

No comments:

Post a Comment