| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter Input for Goal Seek
Need to create code to utilize different cells for goal seek & not just cell
K2. The various cells will be in the same column, but will vary based on the number of years selected (i.e if YR=5, then cell is K, 2+5) from the initial year cell (K2): Range("K2").GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3") -- Kro |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameter Input for Goal Seek
YR = 5
Range("K" & (YR + 2)).GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3") "Kro" wrote: Need to create code to utilize different cells for goal seek & not just cell K2. The various cells will be in the same column, but will vary based on the number of years selected (i.e if YR=5, then cell is K, 2+5) from the initial year cell (K2): Range("K2").GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3") -- Kro |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameter Input for Goal Seek
Thank You!
-- Kro "Joel" wrote: YR = 5 Range("K" & (YR + 2)).GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3") "Kro" wrote: Need to create code to utilize different cells for goal seek & not just cell K2. The various cells will be in the same column, but will vary based on the number of years selected (i.e if YR=5, then cell is K, 2+5) from the initial year cell (K2): Range("K2").GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3") -- Kro |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| Goal seek - Is there a bug? | Excel Discussion (Misc queries) | |||
| How to use goal seek | Excel Worksheet Functions | |||
| goal seek | Excel Discussion (Misc queries) | |||
Linear Mode
