I have good basics in Excel but this situation blocks me I would like to make a VBA code allowing to calculate a target value whose value to reach is present in a variable cell. At each test, excel asks me to put in the value to reach a number and not a cell. This blocks the automation of the process because each time it would be necessary to enter the correct value by hand.
My code :
Sub Macro3()
Application.CutCopyMode = False
Application.CutCopyMode = False
Application.CutCopyMode = False
Range("C22").GoalSeek Goal:=("C23"), ChangingCell:=Range("C13")
End Sub
I'm new to VBA, I think there's a part missing to get to the point thank you very much for the help you are going to give me