vba variable

[Paul]

Looks like I am not handling the variable properly in the
following. Can you tell me what I am doing wrong? the 5th
line causes an error.

Sub Macro1()

Dim point As Integer
point = Worksheets("open").Range("aa1").Value

ActiveSheet.ChartObjects("Chart 10").Activate
ActiveChart.SeriesCollection(1).Points(point).Select
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerStyle = xlCircle
.MarkerSize = 11
End With
End Sub

 

[Chip Pearson]

What error are you getting? Your code works for me.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mika]

I don´t know: your code worked perfectly in my PC.

What does the error message say??

rgd
Mika

 

[Paul]

error message = "unable to get points property of the
series class."

 

[paul]

error message = "unable to get points property of the
series class."

 

[Mika]

Hummmm, go for the "obvious" things:

do you have a value in the cell aa1 ???

do you have a serie 1 ???

It looks to me the problem is in your worksheet and not in the code.

Hi, Chip: if you can help me with the working days function it would
be great...
Rgds
Mika

 

[Paul]

Hummmmm is right! aa1 contains integer. chart contains
series 1 , variable is not outside the series display
range.

the code works fine in my computer too -- only if I use a
number rather than the variable - point.

something with the variable causes it to fail

 

[Mika]

Did you debug the var point after reading the value ??

for example:
debug.print point or msgbox point ??

it is reading the value ?

Rgd
Mika