Formula references
 

Given a formula in a cell, is there a straight-forward way to list all the
cells (or ranges) to which the formula refers?
--
Gary's Student

Formula references
 

If they refer to only cells in the same sheet, you can use

msgbox activecell.DirectPrecedents.Address

also look at Precedents. but these will not return information on links to
other worksheets or external.

--
Regards,
Tom Ogilvy


"Gary''s Student" wrote:

Given a formula in a cell, is there a straight-forward way to list all the
cells (or ranges) to which the formula refers?
--
Gary's Student

Formula references
 

thanks
--
Gary''s Student


"Tom Ogilvy" wrote:

If they refer to only cells in the same sheet, you can use

msgbox activecell.DirectPrecedents.Address

also look at Precedents. but these will not return information on links to
other worksheets or external.

--
Regards,
Tom Ogilvy


"Gary''s Student" wrote:

Given a formula in a cell, is there a straight-forward way to list all the
cells (or ranges) to which the formula refers?
--
Gary's Student

Formula references
 

There's a routine that does this across sheets too in my XspandXL add-in if
you want to give it a try. It's on my site with a free trial.

Robin Hammond
www.enhanceddatasystems.com

"Gary''s Student" wrote in message
...
thanks
--
Gary''s Student


"Tom Ogilvy" wrote:

If they refer to only cells in the same sheet, you can use

msgbox activecell.DirectPrecedents.Address

also look at Precedents. but these will not return information on links
to
other worksheets or external.

--
Regards,
Tom Ogilvy


"Gary''s Student" wrote:

Given a formula in a cell, is there a straight-forward way to list all
the
cells (or ranges) to which the formula refers?
--
Gary's Student