Maybe you could give the user a macro that would copy the row above (including
any formulas).

If you want to try, start at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

You'll have to add something that unprotects the sheet near the beginning and
reprotects the sheet at the end.

Tessa wrote:

I have a ss with formula in locked columns and the whole thing protected to
stop the formula being altered. When the user comes to the last row in
which there is a formula she needs to copy this last row and paste into
however many rows she needs to complete her figures. However the protection
is not allowing the paste function to work.

I know this is probably quite basic but your forum has taught me that I know
very little about Excel.

--

Dave Peterson