Hello,

I'm trying to create a macro that will insert rows between D46 and L46 but not anywhere else. When I use EntireRow, it does just as its name implies and inserts an entire row in the spreadsheet which pushes everything to the bottom.

Is there any way to tell Excel to only insert rows between columns?