When you go to insert, copy the row above where you want to insert, then
right click, paste special formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Riker1074" wrote:

I have a protected worksheet that allows any user to insert new rows. Each
row has 2 formulas and 2 validation managed cells. When a user inserts a
row, the validation is copied, but the formulae are not. How can the
formulae be fromated to fill on inserted rows.
--
Riker1074