Macro to insert specific row BELOW selected cell

Hello,

I was wondering if someone can please have a look at the attached file and fix my little macro accordingly?
Currently it is inserting above the selected/highlighted cell whereas i need it to insert below instead.
The macro is called 'InsertRow'

Any help / suggestions will be greatly appreciated, as you can see i am very new at this!      example.xlsm
vegas86Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

change these two lines of code from

    Selection.EntireRow.Insert
     
    iRow = ActiveCell.Row

to this


    Selection.Offset(1, 0).EntireRow.Insert
     
    iRow = ActiveCell.Row + 1


cheers, teylyn
0
 
vegas86Author Commented:
sorry i forgot to attach the file!
example.xlsm
0
 
vegas86Author Commented:
Thank you SO much for the fast reply Teylyn I did what you suggested and it works a treat! you are a gem!!
0
All Courses

From novice to tech pro — start learning today.