the following code colors a point on the chart line red
when I change the 4th line to

ActiveChart.SeriesCollection(1).Points(1500).Selec t

the same line below contains the variable Rowx and it does
not work. what did I do wrong????

Sub redpoint()

Rowx = [bf44] - 792

ActiveSheet.ChartObjects("Chart 23").Activate
ActiveChart.SeriesCollection(1).Points("Rowx").Sel ect

With Selection
.MarkerBackgroundColorIndex = 3
.MarkerForegroundColorIndex = xlNone
.MarkerStyle = xlSquare
.MarkerSize = 5
End With
End Sub