I have protected a worksheet where I want users to be able to insert a new
column. The information is averaged over however many years are being used.
As a new column is added I need the the count in the aveage column to
increase by 1. Also I need to be able to copy formulas from locked cells
into the corresponding cells in the new column.

For your average, instead of you might try using the COLUMNS function
somehow. Since this counts how many formulas are in a range, and would
increase in size if you insert a column within the range, it might just do
the trick.

--
Best Regards,

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


"nsnyder" wrote:

I have protected a worksheet where I want users to be able to insert a new
column. The information is averaged over however many years are being used.
As a new column is added I need the the count in the aveage column to
increase by 1. Also I need to be able to copy formulas from locked cells
into the corresponding cells in the new column.