Hello guys,

I don't know if there's a way to put the name address in a different sheet within a .Range. In this case, the cell is not fixed, it's random due to the input of the data so that's explain the sInput.Range("AA112"). Here is my code

Sheets("Illustration_Summary").Range("s.Input.Range("AA112")").GoalSeek Goal:=sInput.Range("AA111"), ChangingCell:=sInput.Range("Q110")
Thank you in advance guys