Fixed cell values

[bmcnally]

How can i fix a calculated value in a cell? My worksheet calculates the cost of my power consumption from a unit value in another cell. The unit values are set by the provider and may change over time. I would like to keep the calculated historical cost values rather than have all the cost values recalculated when the provider changes the unit values.

Barry McNally

 

[VoG]

You can copy the cell then Edit > Paste Special, tick Values and click OK. This will replace the formula with its value.

 

[bmcnally]

Thanks Peter that works fine - I was wondering if those actions could be automated?

Barry McNally

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] AsValue()
    ActiveCell = ActiveCell
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[bmcnally]

Thank you Sector - my worksheet will be used to keep track of my solar power production - hopefully, when finalised I will share it with several family and friends.

Barry McNally