| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Macro to Formula References | Excel Discussion (Misc queries) | |||
| Formula with references | Excel Discussion (Misc queries) | |||
| copy formula using same references | Excel Worksheet Functions | |||
Hybrid Mode
