On Sep 24, 9:28*pm, Chantelle
wrote:
Hi All,
I would like to create a macro with a box that allows the user to insert a
row by pressing the button. *I have done this once before but many years ago
and I had a training book! Can someone help me? I know it is fairly simple
but I rarely use macros and I am not sure how to write the code.
Thanks
Chantelle

Hi Chantelle,

This should do it for you. Attach it to a button or set it to a hotkey
under the macro options.

Steven

Sub InsRw()
Dim Rng as Range

Set Rng = ActiveCell.EntireRow

Rng.Insert Shift:=xlDown
Set Rng = Rng.Offset(1,0)
Rng.Select

End Sub