Unable to get Points property of the series class.

  • I am running into an issue when i try to execute this macro in excel (the bold part is where the error happens):


    Sub ZoomIn()



    Dim LeftHorizScale As Long
    Dim RightHorizScale As Long
    Dim TopVertScale As Long
    Dim BottomVertScale As Long
    Dim i As Long
    Dim NumDataPoints As Long
    Dim InitialPoint As Integer
    Dim LastPoint As Integer


    With Selection
    .MarkerSize = 2
    End With



    Sheets("cal & data").Select
    NumberDataPoints = Range("B65").Value


    Sheets("Sigma1vData").Select


    InitialPoint = -1
    LastPoint = -2



    For i = 1 To NumberDataPoints - 1

    If ActiveChart.SeriesCollection(1).Points(i).MarkerSize = 2 Then

    If InitialPoint = -1 Then

    InitialPoint = i
    Else
    LastPoint = i

    End If

    End If
    Next i



    P.S. this error only happens when i have over 14000 rows of data to deal with so i know it has something to do with that but i am just not sure where to proceed. I tried altering all the parameters from integer to long but no success. Any help would be greatly appreciated. Thank you

  • Re: Unable to get Points property of the series class.


    Hi,

    What is the value of i when you get the error (just hover the cursor over the (i) part to find this out when in debug mode).

    That should help identify the problem.

    Thanks,
    Ian

  • Re: Unable to get Points property of the series class.


    17601


    Like i said it has to do with quantity of data (instead of 14k rows it 17600 rows of data is the limit)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!