Hi!

I've been trying to paste formula throughout a range of cells in the same column. Trouble is, I protect some sub-total cells and don't want the formula to paste over those sub-total formulas.

If I protect the sheet and paste the formula throughout the column including the protected cells, I would get an error message.

How can I paste the new formulas without getting into trouble of the protected cells?

Ken

I've been trying to paste formula throughout a range of cells in the same column. Trouble is, I protect some sub-total cells and don't want the formula to paste over those sub-total formulas.

If I protect the sheet and paste the formula throughout the column including the protected cells, I would get an error message.

How can I paste the new formulas without getting into trouble of the protected cells?

Ken

## Comment