Results 1 to 1 of 1

Thread: Excel and initializing series. Strange.

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Jun 2005
    Posts
    41

    Excel and initializing series. Strange.

    This seems like the strangest bug-- I fixed the problem I was having with my previous thread's issue by changing the way I select text into this code:
    VB Code:
    1. ActiveChart.SeriesCollection(1).XValues = Sheets("Snapshot SpdSht").Range("E2", "E50").Offset(0, DoubleCounter)
    2. DoubleCounter=DoubleCounter+1
    However, on the second iteration, the next part,
    VB Code:
    1. ActiveChart.SeriesCollection(1).Values = PVal()
    fails, though it didnt before when I was reading a Values() array into the XValues.
    I dont understand why it gives me a:
    "Unable to set the values property of the series class." error message the second time through this loop.
    Anyone have any ideas? it makes the graph right the first time.
    Thanks

    Edit:This does not only occur on the second loop. Sometimes, It can go through several loops before the error occurs. Strange.
    Last edited by Bartender; Jul 25th, 2005 at 11:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width