How to find “single cell result”of a relative defined name in a VBA code?

soroush.kalantari · #7 07-25-2023, 07:52 PM

Quote:

Originally Posted by Logit

Where did you derive the vba formula :

t = Mid(Right(Selection.Formula, Len(Selection.Formula) - 1), 1, 5)

I have written this formula simply such that to get “price” from it. As I mentioned, my question is not: how to separate a relative name from a formula? but it is: given a relative name of an active cell formula in a vba code, is there some line of code to get “singe cell result address” of this relative name( here the price)?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referencing relative cell	trevorc	Excel Programming	2	08-12-2019 11:56 AM
Relative link (same folder) from Excel cell into Word file	SparFuX	Word	1	12-18-2018 03:22 PM
One Cell that controlls spread sheet result button to change simple fomula result	RAH	Excel Programming	5	03-31-2018 04:52 PM
Sumif to find a single word in a cell without using wildcard	kiteman	Excel	3	08-23-2017 10:14 AM
Worksheet defined cell sums	flextera	Excel	3	06-17-2014 11:12 AM