Adding an "Insert Row" button and have it get placed in a specific place

[mrjack]

Hello everyone. I have created a work template that has 10 steps. Under each step is a list of things that need to be completed in each step. The problem I have is sometimes I will need to add a row under a specific step and keep the formatting from the row above. I am having a hard time figuring out how to add an "Insert row for step #" button. Once a row is added to step 1 everything below it shifts down. I want a button for each step that will insert at the bottom of said step. I am thinking about adding a row at the bottom of each step and calling it "step 1 row addition" then "hiding" that row. So the button can search for that specific text and insert a row above it. That will ensure the row gets added exactly where I want every time. I just cant figure out how to code this. Thank you!

 

[maabadi]

Welcome to MrExcel Message Board
If your row number is i Then

Rows(i+1).Insert

OR

Range("A" & i+1).EntireRow.Insert

And for Copy formatting think this:

Range("A" & i+1).EntireRow.Insert, xlFormatFromLeftOrAbove

OR

Range("A" & i+1).EntireRow.Insert, xlFormatFromRightOrBelow

 

[mikerickson]

Have you considered converting your range to a Table?