ExcelBanter - locking the result of a formula.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - locking the result of a formula. (https://www.excelbanter.com/excel-discussion-misc-queries/209998-locking-result-formula.html)

Claire

locking the result of a formula.

Is there any way of copying and locking the result gained from a formula so
the result doesnt change when cells used in the formula do??

Bernard Liengme

locking the result of a formula.

Copy the cell; then use Edit | Paste Special with Values specified in the
dialog box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Claire" wrote in message
...
Is there any way of copying and locking the result gained from a formula
so
the result doesnt change when cells used in the formula do??

All times are GMT +1. The time now is 07:05 PM.