Insert an entire row using variables.

[jag108]

I am trying to insert a blank row, using variables. I have tried Cells, Rows, Range and cell but nothing seems to work.
sen_num2 = sen_num + 1
Range("sen_num2").Select'trying to select row
Selection.Insert Shift:=xlDown
The sen_num is the position I require, so adding one will make it one row further down so I can then add the row, and populate it with data.

 

[Legacy 11273]

Rows(sen_num2).Insert

Or

Rows(sen_num + 1).Insert
This message was edited by Bali on 2002-10-15 20:27

 

[NateO]

Howdy, might want to follow Jay's advice utilizing resize:

http://216.92.17.166/board/viewtopic.php?mode=viewtopic&topic=6806&forum=2&start=10

edit: For multiple rows, looks like you only want one...
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-10-15 20:31

 

[jag108]

Still failing.
Method Range of object global failed.
I know there is a simple answer, and I thank all those who try.

 

[jag108]

Worked, I knew there was a simple answer.

Thanks heaps.