Add row at specific location using vba

[hrbreton]

Hi All,

I have a spreadsheet (testing - attached) that has several sections with buttons that add and remove rows for that section. In my attached spreadsheet, the add button is only functional for Objectives. My code adds a new row after whatever cell is selected. I need it to go to a cell I've named "OBJ", select the row above it, copy and paste so the cell "OBJ" gets moved down to the next row (to be used if another row is added). The code I have so far is below, it copies the selected row and adds a new row below it, not quite what I am looking for:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Thanks.

[Leith Ross]

Hello hrbreton,

Welcome to the Forum!

Both "add" buttons have the new macro attached to them. This uses the position of the button along with the bordering empty rows to determine the last row. There must be at least 3 rows present before the row will be copied. The two headers rows are excluded. The attached workbook has the macro added.

Please Login or Register  to view this content.

[hrbreton]

Thanks for your reply. I have written some vba which does the trick. I hope it helps someone else:

Please Login or Register  to view this content.