Variable Not Defined Error!

[sameerdoda]

Hi All

I am trying to automate the goal seek function and found the following code on one of the sites. The code is supposed to run whenever any changes are made to the sheet. However, I get a "Variable Not Defined" error and C9 is highlighted.

Option Explicit


Private Sub Worksheet_Calculate()
CheckGoalSeek
End Sub


Private Sub CheckGoalSeek()
Range(“C12”).GoalSeek Goal:=0, ChangingCell:=Range(“C9”)
End Sub


I am very new to macros and any help will be really appreciated!

 

[Rick Rothstein]

Try deleting the quote marks you have around both C12 and C9 and then retype the quote marks using your keyboard and see if that corrects the problem.

 

[sameerdoda]

Try deleting the quote marks you have around both C12 and C9 and then retype the quote marks using your keyboard and see if that corrects the problem.

Thanks a lot! It worked. And for anyone referring to this thread in the future I used the following code :

Option Explicit
 
Private Sub Worksheet_Calculate()
CheckGoalSeek
End Sub
 
Private Sub CheckGoalSeek()
Static isWorking As Boolean
 
                If Round(Range("SetCell").Value, 6) <> 0 And Not isWorking Then
isWorking = True
Range("ByChangingCell").Value = 0
Range("SetCell").GoalSeek Goal:=Range("ToValueCell"), ChangingCell:=Range("ByChangingCell")
isWorking = False
End If
End Sub