Thanks for your efforts. I was a little surprised to discover that I could
apply a Method (ShowPrecedents) to a cell, and not have a Property to verify
it had been done.

I later realized that I was just dropping Shapes on the worksheet and maybe
the Shapes could supply the info......
--
Gary''s Student - gsnu200909


"Rick Rothstein" wrote:

I've been looking at your problem from when you first posted it... yes, the
Formula Auditing does seem to matter. A normal line has a TopLeftCell and a
BottomRightCell property which you can reference to get their Address
properties; however, lines drawn by the Formula Auditing appear to be
different in that they do not have these properties. I'm still looking (on
and off) at some ideas on how do solve your problem though.

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
Somewhere on my worksheet is a single Shape. It is a line with an
arrowhead
at one end. The line begins in one cell and ends (arrow head side) in
another cell. How can a macro determine the address of these two cells?

If it matters, the line was drawn by Formula Auditing.

Thanks
--
Gary''s Student - gsnu200909

.