+ Reply to Thread
Results 1 to 1 of 1

Run-time Error 91 in MS code

  1. #1
    Registered User
    Join Date
    12-08-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Run-time Error 91 in MS code

    Hello!

    I'm new to this vbaexcel stuff so please pardon the simplicity of this...and thanks beforehand to anyone who even reads this!

    I've tried using this code here to label my scatter plot:
    http://support.microsoft.com/kb/213750#appliesto

    but everytime I run it again to adjust for changes in my data it gives me the following error:

    Run-time Error '91'
    Object variable or With block variable not set

    The line that highlights in the debug window is: xVals = ActiveChart.SeriesCollection(1).Formula

    I looked at the definition online of this error but I'm not sure what the object is in the code...

    Any ideas why it's not working?
    I know an add-in exists but I don't want to use it.

    Thanks again! Any help is much appreciated .
    Last edited by sparklingcider; 12-08-2009 at 05:23 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1