PDA

View Full Version : Cell Address Goal Seek



truc.tu
03-04-2020, 07:52 PM
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