Posted to microsoft.public.excel.programming

external usenet poster

Posts: 6

How to get variable from a formula

Hi,

I would like to ask, whether it is possible to get information of a variable
in a formula, I mean:

Cell B1 contains formula:

=SPEC("Green","Apple",98),

is that possible somehow to reach the middle parameter of the function, that
is "Apple"?

Is there any VBA function like:

needed = Cells(1,2).Formula.Parameter(2)

Thanks in advance

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
formula containing a formula-dependent variable - how?	CompeterN	New Users to Excel	1	November 8th 06 02:02 PM
Using a second variable within a formula...	Ed Anton	Excel Discussion (Misc queries)	2	February 18th 05 11:51 AM
use a variable in a formula	Marcotte A	Excel Programming	2	August 26th 04 01:24 AM
Variable in a Formula	Amy Ja	Excel Programming	3	April 21st 04 01:22 AM
Formula Variable	Ronbo	Excel Programming	3	March 4th 04 09:33 PM

All times are GMT +1. The time now is 03:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us