vba variable
 

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).Sele ct
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerStyle = xlCircle
.MarkerSize = 11
End With
End Sub

vba variable
 

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


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


"Paul" wrote in message
...
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).Sele ct
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerStyle = xlCircle
.MarkerSize = 11
End With
End Sub

vba variable
 

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

What does the error message say??

rgd
Mika

vba variable
 

error message = "unable to get points property of the
series class."
-----Original Message-----
I don´t know: your code worked perfectly in my PC.

What does the error message say??

rgd
Mika

.

vba variable
 

error message = "unable to get points property of the
series class."
-----Original Message-----
What error are you getting? Your code works for me.


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


"Paul" wrote in
message
...
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).Sele ct
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerStyle = xlCircle
.MarkerSize = 11
End With
End Sub


.

vba variable
 

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

vba variable
 

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

-----Original Message-----
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

.

vba variable
 

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