ExcelBanter - Parameter Input for Goal Seek

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Parameter Input for Goal Seek (https://www.excelbanter.com/excel-discussion-misc-queries/215346-parameter-input-goal-seek.html)

Kro

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

joel

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

Kro

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

All times are GMT +1. The time now is 11:59 PM.