Using INDIRECT in VBA for Goal Seek

[JV0710]

Good Day All

Please can I get help with the following:

I am trying to do Goal Seek in VBA but I want to use the INDIRECT function to reference the cells and values

my recorded macro is as follows
*************************************************************************************
Sub mygoalseek()
'
' mygoalseek Macro
'

'
Application.CutCopyMode = False
Application.CutCopyMode = False
Application.CutCopyMode = False
Range("D2").GoalSeek Goal:=52535, ChangingCell:=Range("D15")
End Sub
*****************************************************************************************
In cells K1, K2 and K3 I have cell Addresses refering to the goal seek parameters

Where I have Range("D2") in the Macro - I want to reference the cell address in K1
Where I have Goal:=52535 in the Macro - I want to reference the cell address in K2
Where I have ChangingCell:=Range("D15") in the Macro - I want to reference the cell address in K3

I think that using the INDIRECT function will be correct, but I do not know how to edit the macro accordingly

Thanks in advance for your help

 

[JV0710]

Good Day Stephen

Just some feedback

File is working fine now. I re-wrote the whole thing from scratch and now it seems to be working. Don't know for sure what was wrong . but it's fine now

Thanks once again for your help

 

[StephenCrump]

File is working fine now. I re-wrote the whole thing from scratch and now it seems to be working. Don't know for sure what was wrong . but it's fine now

Great, I'm glad you got it working. Thanks for posting back.