Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auditing and graphs
I would like to be able to tell if a cell is being used in any graph in my
workbook. The standard <Audit <Show dependants does not seem to concider Graphs as dependents (Help specifically talks about dependent "cells" in the auditing write up) Is anyone aware of a built in method for determining whther a cell is used in a chart, or does anyone have a recomended macro I can build on? |
#2
|
|||
|
|||
You are right in that the 'Show Dependents' doesn't consider graphs as
dependents. In fact, there is no easy way to find all the cell references in a workbook. As far as graphs go, even if you are not using a data label (or textbox) linked to cells, you would still have to parse the content of the SERIES formula associated with each individual series of each chart in the workbook. To help you get started see John Walkenbach's http://j-walk.com/ss/excel/tips/tip83.htm -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... I would like to be able to tell if a cell is being used in any graph in my workbook. The standard <Audit <Show dependants does not seem to concider Graphs as dependents (Help specifically talks about dependent "cells" in the auditing write up) Is anyone aware of a built in method for determining whther a cell is used in a chart, or does anyone have a recomended macro I can build on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|