Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Charts.add ???

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Northern Ireland
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to insert 2 charts into 2 separate sheets using a macro. My code for 1 graph seems to be fine, but when I introduce the code for the 2nd graph, I either get an excel message box stating that I have not enough memory or else my code has an error at the line: -
    charts.add

    Has anyony ever come across this before and what would you recommend that I do.
    By the way I'm using Excel 97.

    Thank you

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check that you have the sheet where the chart goes activated.

    Like

    ChartSheet.Activate
    ChartSheet.Charts.Add

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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