Thanks, but that means that the row is always inserted on row 11. I wan
it to insert on the same row as the button was when pressed, regardles
of where that button was positioned because it will move down as row
are inserted.
i.e. perhaps something like myrowtouse = the same row the button i
when pressed.
Is there anyway of doing this?
Nejl
GJones wrote:
[b]Hi nejlangton;
Sub NEWRMO2()
'
' NEWRMO Macro
' Macro recorded 02/09/2004 by charles
'
'
Sheets("Template").Select
MyRowToUse = 11
Rows("11:11").EntireRow.Copy
Sheets("Risk Register").Select
Cells(MyRowToUse, 1).Select
ActiveCell.Offset(0, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown
End Sub
Thanks,
Gre
--
Message posted from
http://www.ExcelForum.com