replacing cell references with value within a formula

[mynameisnfs]

Hi:
Several years ago (between 2013 and 2018??) I found and tweaked code which would do the deceptively simple task of replacing cell references with their values in a selection. For example, if A1=10, and A5=15, and formula in C3 was =A1+A5, then it would change C3 to =10+15, i.e. retain the basic math. It worked over a selection, whether row or column. I don't recall if it worked with absolute references (e.g. $A1 or A$1), but that's not an issue here. Hopefully I have terminology right.

Unfortunately I seem to have lost this code, and after spending an hour searching google and the two major excel forums, I've been unable to find this. I'll keep searching.

Meantime, would someone happen to have the post bookmarked or saved?
Thank you for any leads here!

[Richard Buttrey]

Maybe something like

Range("C1") = "=" & Range("A1").Value & "+" & Range("B1").Value


Incidentally would you set your location to something meaningful please. It can often help if we need to consider stuff like Regional settings or date formats

[mynameisnfs]

Thank you. I just found code from another site which works only on the active cell, and has author credit in it from 2005. Not sure I'm allowed to post it. Parts of the code don't make sense to me what it is doing. It accomplishes the task but have to do it cell by cell. I suppose I could call that function and pass it a specific cell by looping through the selection.

Going to keep searching. Wish I could find it from a few years ago, it was so elegant and clean. Funny how the results today in both google and the forums are so different from 5+ years ago.