if that wasn't enough try this...
Rows("1:10").Insert

Die_Another_Day
Jim Thomlinson wrote:
You anc take any range and expand it to encompass the entire row and then
just insert. here are a few examples...

Sub TestInsert()
Dim rng As Range

Set rng = Range("A2")
rng.EntireRow.Insert

Range("A4:C6").EntireRow.Insert

Range("9:9").Insert
End Sub
--
HTH...

Jim Thomlinson


"Taru" wrote:


What are some commands to insert a row with VBA?


--
Taru
------------------------------------------------------------------------
Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494
View this thread: http://www.excelforum.com/showthread...hreadid=553684