View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MUEEN SEHDI[_2_] MUEEN SEHDI[_2_] is offline
external usenet poster
 
Posts: 5
Default Inputs for Goal Seek Command

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.