Thread: Goal Seek

Im using this code to update a goal seek method if something changes

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 19 And Target.Column = 13 Then
Range("P19").GoalSeek Goal:=Range("M19").Value, _
ChangingCell:=Range("P9")
End If
End Sub


But how could i do the same but if a cell in "sheet A" changes but i want the goal seek to run in "Sheet B".

Hi,

You can be specific about each range ...

ChangingCell:=Sheet2.Range("P9")

HTH