Hi,

I have a macro to insert a line and copy the formulas from the selected row (only some of the cells), but when I run it it keeps the data that I have entered in the cells as well as the formula... I would like it more if I could figure out a paste special or something like that... I used the offset feature to .clearcontents, but that seems junky to me.

Secondly, I have the sheet protected; when I select the button from the review tab "protect sheet" I am given options to allow formatting of cells that are not locked, but when I run my macro to insert the line and use

activesheet.unprotect

"insert row"

activesheet.protect

I loose my ability to format unprotected cells on the page... I don't want to create a bunch of macro buttons as it will look pretty bad. is there a switch or something that I can turn on using the .protect code that will also turn those formatting options back on?

Lastly, I have only been able to insert a row above where I have selected, but would like two buttons, one to insert a row above (got that one) and one to insert a row below (can't figure that one out) and still keep my formatting (formulas in the 4th 6th 8th and 9th cells).

Truly appreciated if anyone can help on any of these problems.