red point

[Paul]

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

ActiveChart.SeriesCollection(1).Points(1500).Select

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").Select

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

 

[Guest]

Try removing the quotes around "Rowx"

 

[Guest]

Paul,

ActiveChart.SeriesCollection(1).Points(Rowx).Select


"Rowx" (in quotes) is treated as a string not a number variable which I
think is what you want.

HTH