I have following formula working. But the new row is not protected. Is there
a way to have the macro lock the cells with the formula so they cannot be
updated by users?

Thanks

"Kesbutler" wrote:

I have a worksheet that I need to insert rows but copy only the formulas from
the row above. Any suggestions?