|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
07-22-2023, 04:46 AM
|
|||
|
|||
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? 
|
| Tags |
| evaluate, relative defined names |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode