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!
Bookmarks