I'm trying to add Goal Seek to a little VBA because I want to use on multiple cells and not have to enter the changing value in each of them individually.
If the value of Q1 changes, then the value of Q13 through AB13 should change to match the value of Q1
use Goal Seek to find Q11 through AB11
I'm trying the following which is NOT working:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$Q$1" Then
Range(“Q13:AB13”).GoalSeek Goal:=.Range("$Q$1").Value, _ ChangingCell:=Range(“$Q11:$AB$11”)
I don't ever remember working with Excel VBA before. Can anyone help me correct this?
Thanks so much!