Printing Charts is a stupid thing to get frustrated over

[fredalina]

And yet, here I sit, frustrated as can be.

I have an Excel document with a national worksheet and 10 regional worksheets. Each sheet has a chart associated with it called "Chart 1". I want to print all 11 "Chart 1"s. I can print all 10 regional charts, but the national worksheet prints the entire worksheet rather than just the chart -- this is 4 pages long.

I have tried the following, to no avail:

• Creating a macro for the national chart separately
• Creating a macro that loops through for x = 1 to 11 and then has a Select Case to assign the worksheet names and then prints that way (theoretically the cleanest method, but no more effective)
• Creating a macro that individually names all 11 worksheets and prints the charts
• Going to another sheet first, or copying and pasting data, just so there's some other operation before the print, and none of that works either
• Manually re-naming "National" and "Region1" to switch the names. This was interesting: the NEW "Region 1" (old "National") still had the same issue, and the new "National" did not, which makes me think it's a worksheet or chart issue and not a macro issue, so then I tried...
• Deleting "Chart 1" in the national sheet and re-creating it and then re-naming it "Chart 1" (because it wants to call it "Chart 6" for some reason, even though there are no other charts that I can find, which makes me wonder if this is related...)

Can anyone help? It's certainly possible to print by hand the National page and then run a macro to print the remaining regions, and that works fine, but it seems like it should be totally do-able in VBA and I'm probably missing something simple or obvious.

Thanks!

 

[Trevor G]

Are your charts on Separate Worksheets or are they objects on the worksheets?

This code will print all chart sheets

Charts.PrintOut