How to find “single cell result”of a relative defined name in a VBA code?
I am seeking a way to find the “single cell result” of relative defined names in VBA codes. (see the excel attachment in which the name “price” has been defined. (for example, if select G3 in a vba code and somehow separate the “price” in its formula, I am seeking a way to get “G1” which is the “single cell result” of price name in this cell. as the picture attachment shows, it can be achieved manually by formula/evaluate formula/step in/evaluate.)
Can you guide me on this issue?
|