You can't run Goal Seek from a worksheet formula. You could write a macro to
automate it, or even record a macro while you do the particular analysis,
and rerun it as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"lawson" wrote in message
...
Hello,

i wish to create a function that runs GoalSeek.

if, for example, A1 is where i sould type the function, then B1 would be
the
value to be set, and C1 would be the cell to change till it equals B1, by
changing the value in A1.

A1 = GS(Target Value, Cell to be set to Value)
= GS('B1','C1') '(ie, can be typed in any cell, referencing any cells)

which would produce a value that looks like a typical Goalseek value,
2.639568392784

any help would be greatly appreciated

G