Auditing

V

vikesh

to track the antecedents or precedents for a particular cell, you ca
use the menu/tool/auditing function.

but i want similar functionality for a group of cells which may b
adjacent/ non-adjacent.

can anybody help ???

i am using Excel 2000

thanx in advance

Vikesh Jai
 
B

BrianB

Don't understand the question. Auditing works depending on which cel
references are involved, so it does not matter where they are in th
sheet
 
V

vikesh

assume there are 7 cells in a worksheet (A1: A7), all of them deriv
their value from some other cells (say Z72: Z79) in the same woksheet
now i want an arrow that shows from where cell A1 derives this value.

for highlighting this i use the auditing toolbar/trace precedent
command.

My question is that when this option works for highlighting th
precedents & dependents for one particular selected cell (in my exampl
cell A1)- Is there some way that these operations can be carried out o
a series of selected cells (e.g. in the example- I select Cell A1: A
and want that the precedent cells i.e. Z72: Z79 are highlighted wit
the help of an arrow
 
D

Dave Peterson

There's a toolbar you can show that will allow you do to this pretty quickly.
Just click on your favorite cell and click the "show precedents" icon.

In xl2002, it's the "formula auditing" toolbar. (In some versions, I think it's
called just "auditing".)

But you could select your range and run a macro to get all the cells in the
selection:

Option Explicit
Sub testme02()
Dim myCell As Range

For Each myCell In Selection.Cells
myCell.ShowPrecedents
Next myCell
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top