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

Logit · #1 07-24-2023, 09:39 AM

G1 displays a formula ( =F1+10 ) that creates a result of : 100 .

Are you wanting to obtain the formula or the value 100 ?

soroush.kalantari · #2 07-24-2023, 07:50 PM

Quote:

Originally Posted by Logit

G1 displays a formula ( =F1+10 ) that creates a result of : 100 .

Are you wanting to obtain the formula or the value 100 ?

I am wanting to obtain the cell address($G$1 or G1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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