Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert Row before Macro Button
How do I create a macro which will allow me to insert a row on top. Eg I have data in C3..H10. Row C11..H11 is blank but cells are formatted (general, currency etc.). I have a macro button on B11, with the following procedure attached to the button; Sub InsertLineAbove() ActiveCell.Offset(0,0).Range("A1").Select Selection.EntireRow.Insert ActiveCell.Offset(1,0).Range("A1").Select End Sub The probelm is when my cursor is on B11 or C11, it works beautifully, but if the cursor is anywhere else and I click on the button (located at B11) then it insert a line at the point where the cursor was. Which is exactly what I don't want. Thanks Kieranz PS Admin, suggestion to help newbies - is it possible to have a guide in pdf which can be downloaded to read at leisure on using the forum etc. -- Kieranz ------------------------------------------------------------------------ Kieranz's Profile: http://www.excelforum.com/member.php...o&userid=27663 View this thread: http://www.excelforum.com/showthread...hreadid=471787 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) |