Posted to microsoft.public.excel.programming

Caio Milani[_2_] Caio Milani[_2_] is offline

external usenet poster

Posts: 1

How to use/evaluate another Cell Formula in R1C1 style

I am trying to create a formula to evaluate another cell formula from the
formula caller cell address.
Supose a have
a b
1 10 30
2 20 40
3 =A1+A2 =udfEvaluate(A3)

the user-defined-formula udfEvaluate should retieve B1+B2=70, i.e., A3 cell
formula evaluated from its perspective = R[-2]C+R[-1]C

P.S. The real formula is huge and does not fit in name-defined.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using INDIRECT & R1C1 Ref style	Bassman62	Excel Worksheet Functions	5	November 5th 08 09:38 PM
R1C1 reference style	Helpme Please[_2_]	Excel Discussion (Misc queries)	5	July 11th 07 11:12 PM
How do I change sheet notation from R1C1 style to A1 style in XL 2	Sherlock1506	Setting up and Configuration of Excel	1	December 5th 06 03:22 PM
can a1 reference style and r1c1 style be used in same formula?	rjagga	Excel Worksheet Functions	1	September 17th 06 10:58 AM
R1C1 reference style	Peg P	Excel Discussion (Misc queries)	2	November 15th 05 06:48 PM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us