Hello,
I am trying to create a macro that will insert rows when a button (assigned macro to a shape) is pressed. But there are catches; I need to insert a row directly above the button, regardless of which cell is selected in the worksheet. I also plan on putting numerous buttons within one worksheet as I need to add rows to “subtotal” categories.
The button is the height of the cell. When I click on the button it will insert a row directly above the button (and the button will move down with the cell).
Any suggestions?