In the code below, why do I keep getting an Object required error?
It happens on the Set CellChange below. Isn't my syntax correct?
Option Explicit
Sub Worksheet_Calculcate()
Dim objCht As ChartObject
Dim CellChange As Long
Set CellChange = Sheets("Price Bridge Chart").Range(2...