I need to change the range to finish on D27 now, easy peasy, I thought.

I unprotected the sheet, and changed the value.................it wont work.

The formula is displayed in the cell instead of the answer??

The answer is used in another sheet, but I even tried copying the sheet to a new workbook and changing the formula to no avail. I'm sure it must be something stupid, but I am a fafirly competent excel user and have never been unable to change a formula in a sheet???

Help please.

Ps , I cannot change ANY of the formulas in the sheet not just this one