| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seeking to a Cell instead of a hard number
I am trying to goal seek to a specific cell. Is it possible to do so without
typing in a hard number? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Goal Seeking to a Cell instead of a hard number
Nate.
You would need to use code: Sub NateGoalSeek() Range("A3").GoalSeek Goal:=Range("A2").Value, ChangingCell:=Range("A1") End Sub In this example, we are seeking to set the value returned by the formula in cell A3 equal to the value entered in cell A2 by changing cell A1 (all of the activesheet). HTH, Bernie MS Excel MVP "nate" wrote in message ... I am trying to goal seek to a specific cell. Is it possible to do so without typing in a hard number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hard CR in a Cell | Excel Discussion (Misc queries) | |||
| Hard values to convert to number | Excel Discussion (Misc queries) | |||
| Seeking an alternative to blank ("") cell in IF arguments | Excel Discussion (Misc queries) | |||
| formula won't work unless column of data is a hard number | Excel Worksheet Functions | |||
| Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) | |||
Linear Mode
