JimmyM1975
New Member
- Joined
- Feb 11, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
VBA for Find (and Find/Replace) in series formulae of charts.
I have about 50 workbooks with 20-100 sheets and 50-500 charts in each. Occasionally I need to delete rows with data charted somewhere. This casues the "Excel found a problem with one or more formula references in this worksheet" error and ~Refs inside the series formula of several hundred charts. As find + replace doesnt search in charts we use the VBA from here VBA Charting Techniques but it doesn't do find only (it only does find+replace). I am trying to quickly identify a list to directionally point my to the charts that contain a #ref!. Some have kindly suggested this website: Change Series Formula - Improved Routines - Peltier Tech Blog where for $99 you can by this tool BUT my firm policy wont allow it.
Does anyone have the VBA?
I have about 50 workbooks with 20-100 sheets and 50-500 charts in each. Occasionally I need to delete rows with data charted somewhere. This casues the "Excel found a problem with one or more formula references in this worksheet" error and ~Refs inside the series formula of several hundred charts. As find + replace doesnt search in charts we use the VBA from here VBA Charting Techniques but it doesn't do find only (it only does find+replace). I am trying to quickly identify a list to directionally point my to the charts that contain a #ref!. Some have kindly suggested this website: Change Series Formula - Improved Routines - Peltier Tech Blog where for $99 you can by this tool BUT my firm policy wont allow it.
Does anyone have the VBA?