VBA charts update - dynamically test sheet type for two types of charts

[kapucino]

working on short piece of VBA code. Situation: 200+ charts in workbook need some update ( for example Y axis scale).

I managed to write two Sub's:

- one updating charts on Worksheets ( beside tables)
- one updating standalone charts on Chart sheets

Would be nice to have solution that would dynamically test Current sheet type and each sheet type in a loop and select appropriate/run appropriate Sub for either chart on worksheet or standalone.

Any suggestion?

Please Login or Register  to view this content.

[kev_]

Try this:
- run first with message boxes to see if it provides the correct split for you
- then call your 2 procedure instead of building up message strings

- procedure returns message box listing each chart by sheet:

SheetsByType.jpg


In general module:

Please Login or Register  to view this content.