+ Reply to Thread
Results 1 to 1 of 1

Problem with a Chart when looping through sheets

  1. #1
    Registered User
    Join Date
    05-25-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2003
    Posts
    19

    Problem with a Chart when looping through sheets

    As a new VBA person, I have searched all over the place for an answer, but I could really use some help.

    I have a macro I use when developing a new Workbook that sets all sheets up for easy use. I also have another macro that undoes all that to see what the finished product will look like. Both macros have been working great, until today when I inserted a Chart into one of the sheets. The code is listed below and blows up when it get to the ".DisplayHeadings = True" line. I have figured out that the code does not work with a chart, but I need to know how to identify the chart in order to insert an IF-ENDIF function to work around it.

    Please Login or Register  to view this content.
    Last edited by jcaskey; 08-06-2013 at 08:13 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looping through sheets to clear a specified range, but excluding some sheets
    By d.sanchez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2013, 02:39 PM
  2. [SOLVED] Multiple Sheets be reflected in 1 sheets as a summary (looping)
    By Kooper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 03:21 AM
  3. Chart Looping through 2,200 sheets
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2011, 07:46 PM
  4. Looping through sheets
    By Aussie_Striker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2006, 11:28 AM

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