I am using Excel 2010. I want to use a relative reference to goal seek using a "ChangingCell" that is in a different worksheet...
ActiveCell.GoalSeek Goal:=0, ChangingCell:=Sheets("Volumes").Range("O11")
... but I am getting an error message that the reference is not valid. What should I call the ChangingCell on the "Volumes" sheet so that it relates to the ActiveCell (which is Q23 on a sheet called "Results")?
Also, I would like the ChangingCell to also be relative in that it moves down rows as my original "Active Cell" moves down?
ie ActiveCell is "Results Q23" and ChangingCell is "Volumes O11", so if the ActiveCell is "Results Q24", the ChangingCell needs to be "Volumes O12".
Is this even possible? Thanks very much.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
ActiveCell.GoalSeek Goal:=0, ChangingCell:=Sheets("Volumes").Range("O11")
... but I am getting an error message that the reference is not valid. What should I call the ChangingCell on the "Volumes" sheet so that it relates to the ActiveCell (which is Q23 on a sheet called "Results")?
Also, I would like the ChangingCell to also be relative in that it moves down rows as my original "Active Cell" moves down?
ie ActiveCell is "Results Q23" and ChangingCell is "Volumes O11", so if the ActiveCell is "Results Q24", the ChangingCell needs to be "Volumes O12".
Is this even possible? Thanks very much.
Last edited: