free cell

Some of still use 2000 <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John Lyons" <JohnLyons@discussions.microsoft.com> wrote in message
news:41FFD689-3514-4CA4-BDA4-A3C25EF4A22F@microsoft.com...
> or just use the Find Dependents tool on the Audit toolbar!
>
> "Gary''s Student" wrote:
>
> > How can I tell if a cell is free (available)?
> > Free would mean empty and not referred to by another cell on the
worksheet.
> >
> > --
> > Gary''s Student

Trace Dependents/Precedents icons are available in 2000 (and '97, I think)
when you customize the toolbar & look in the Tools category<g>


"Bob Phillips" wrote:

> Some of still use 2000 <vbg>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "John Lyons" <JohnLyons@discussions.microsoft.com> wrote in message
> news:41FFD689-3514-4CA4-BDA4-A3C25EF4A22F@microsoft.com...
> > or just use the Find Dependents tool on the Audit toolbar!
> >
> > "Gary''s Student" wrote:
> >
> > > How can I tell if a cell is free (available)?
> > > Free would mean empty and not referred to by another cell on the
> worksheet.
> > >
> > > --
> > > Gary''s Student
>
>
>

You are right, I had forgotten since I never use them, and was thinking of
the much stronger Evaluate facility in the XP Auditing tool <g>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:0B64281B-E6D8-427A-AE3D-EB7F68B0DA39@microsoft.com...
> Trace Dependents/Precedents icons are available in 2000 (and '97, I think)
> when you customize the toolbar & look in the Tools category<g>
>
>
> "Bob Phillips" wrote:
>
> > Some of still use 2000 <vbg>
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "John Lyons" <JohnLyons@discussions.microsoft.com> wrote in message
> > news:41FFD689-3514-4CA4-BDA4-A3C25EF4A22F@microsoft.com...
> > > or just use the Find Dependents tool on the Audit toolbar!
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > How can I tell if a cell is free (available)?
> > > > Free would mean empty and not referred to by another cell on the
> > worksheet.
> > > >
> > > > --
> > > > Gary''s Student
> >
> >
> >