Parameter Input for Goal Seek

K

Kro

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")
 
J

Joel

YR = 5
Range("K" & (YR + 2)).GoalSeek Goal:=ParameterPF, ChangingCell:=Range("D3")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal seek - column reference 3
Goal Seek tool in a macro 1
Do Loop Goal Seek won't End Sub 2
Goal Seek with dynamic Goal Seek 1
vba goal seek 2 1
Using Goal Seek without a macro 1
Loop several sheets - part 4 - Dave Peterson - Goal seek 1
Goal Seek Advice 2

Top