Insert Row before Macro Button

  • Thread starter Thread starter Kieranz
  • Start date Start date
K

Kieranz

How do I create a macro which will allow me to insert a row on top. E
I have data in C3..H10. Row C11..H11 is blank but cells are formatte
(general, currency etc.). I have a macro button on B11, with th
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 (locate
at B11) then it insert a line at the point where the cursor was. Whic
is exactly what I don't want.

Thanks
Kieranz

PS Admin, suggestion to help newbies - is it possible to have a guid
in pdf which can be downloaded to read at leisure on using the foru
etc
 
On click of the button (on B11) I should be able to copy that ro
(including formulaes, format etc) one line above, irrespective wher
the cursor may be positioned. That way I can continue to add rows onl
as I need them.
Many thk
 
Back
Top