Without seeing the actual problem, my guess would be that you would be
better off using Solver.
Solver is far more powerful that Goal Seek
Do you wish to share with us a sample problem?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"MUEEN SEHDI" wrote in message
...
This query is with reference to Goal Seek function in Excel 2007.

While entering the inputs for its dialogue, the second parameter ""To
Value"
has to be entered manually as a value. Instead of entering value here, we
can
not reference this field to any cell in worksheet (As the application does
not allow you for this).

Is there any alternative solution to declare some deafult cell locations
as
inputs to all 3 fields of the Goal Seek dialogue thus automating the
inputs
and getting the result staright away.