Please Register to Remove these Ads
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".
Linear Mode
