Insert row at the bottom (specific range of columns)

Hi,

I'm trying to write a macro that will add a new row at the bottom of a spreadsheet for a specific range of cells.

Please take a look at the attached Excel spreadsheet.

I want to be able to add a new row from column A to E. The new row would need to be added at the bottom, in this case below row 5 and push the row with the "Total" one row below.

In my current spreadsheet, if you try the macro (CTRL+A), you will notice that the macro adds the new row above the row 5 instead of below.

Any help would be greatly appreciated.

Hello marcmarina,

I cannot find any Code in your WorkBook to help you with.

hope that helps!

Hi,

just change the following line in you macro

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

As I see, the "insert" method inserts a row above (not below) the selected range.

I hope it works at your computer too. :D

ooops. double post. see previous post.

marcmarina,

Try the attached WorkBook.

Certainly,

Just replace the Code in the WorkBook with the Code below.

Please Login or Register  to view this content.

Hello marcmarina,

I apologise. The Code I have given you does not do exactly what you have asked for.

See attached WorkBook with corrections which now complies to your request.

Also see the "Please consider" note at the bottom of this post, and mark your Thread as Solved, if you are satisfied with the solution provided.