macro that inserts a row

**TBM** · 05-19-2016, 03:08 PM

Any help would be appreciated
I have a macro that uses a command button to insert another row at the top of a sheet.

I would like it to copy the top two rows of the sheet as well as any formatting. without the contents.
and then add those 2 rows to the top.

Here is the one that I have started with.

Please Login or Register  to view this content.

Thanks for any help

**mikeTRON** · 05-19-2016, 04:44 PM

There are more efficient ways to do it, but I think this is the easiest to understand for someone who is not a wizard with VBA.

Please Login or Register  to view this content.

If you want to only do it on SHEET1, then that needs to be explicitly added on, otherwise this will run on the active sheet. In other words if the button is on another sheet, then add the sheetname, otherwise you are good.