link goal with excel in goal seek macro

[Dolf]

Hello,
I recorded a macro for a goal seek and goal cell and variable input I can link to excel, however if I want to change the goal value, I have to go into the macro and change it there.
Tried to name the goal cell and enter that in the macro, but that doesn't work.
Anyone has a solution?

 

[mse330]

Hello Dolf,

It would be easier to solve your issue if you post your code. However, I have just set the below example for you perhaps it clarifies things out

Sub Macro1()

Dim Goal_Value As Double
Goal_Value = ActiveSheet.Range("A1").Value ' Change this to the desired sheet/cell reference

Range("C6").GoalSeek Goal:=Goal_Value, ChangingCell:=Range("C4")

End Sub

 

[Dolf]

Thanks mse330! I think I understand what you mean, I'll give it a try

 

[Dolf]

Thanks mse330! I think I understand what you mean, I'll give it a try

Super it works!!! Thanks a lot

 

[mse330]

Great .. I am glad I could help & thanks for reporting back