Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell has an external reference ...
All,
Is there a way to determine whether a range (cell) has an external reference (e.g. ='C:\Documents and Settings\M100C\My Documents \Spreadsheets\[networth.xls]Sheet1'!$E$1) without parsing the Formula property? I could not find any other range properties that seemed to unambiguously indicate that the source of data was outside the workbook. If not, I have not considered all of the potential Formula property values for various data sources, and if parsing is needed, is there a specific string or characters (maybe[*]) that would indicate that the range has an external reference. Thanks, Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell has an external reference ...
In Excel help search for " Display the relationships between formulas and
cells " "M100C" wrote: All, Is there a way to determine whether a range (cell) has an external reference (e.g. ='C:\Documents and Settings\M100C\My Documents \Spreadsheets\[networth.xls]Sheet1'!$E$1) without parsing the Formula property? I could not find any other range properties that seemed to unambiguously indicate that the source of data was outside the workbook. If not, I have not considered all of the potential Formula property values for various data sources, and if parsing is needed, is there a specific string or characters (maybe[*]) that would indicate that the range has an external reference. Thanks, Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell has an external reference ...
Using VBA:
ActiveCell.ShowPrecedents 'To show the arrows ActiveSheet.ActiveCell.ShowPrecedents remove:=True "M100C" wrote: All, Is there a way to determine whether a range (cell) has an external reference (e.g. ='C:\Documents and Settings\M100C\My Documents \Spreadsheets\[networth.xls]Sheet1'!$E$1) without parsing the Formula property? I could not find any other range properties that seemed to unambiguously indicate that the source of data was outside the workbook. If not, I have not considered all of the potential Formula property values for various data sources, and if parsing is needed, is there a specific string or characters (maybe[*]) that would indicate that the range has an external reference. Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to cell with external spreadsheet | Excel Worksheet Functions | |||
Using cell value to build external reference | Excel Discussion (Misc queries) | |||
Using cell value to reference external worksheet? | Excel Worksheet Functions | |||
External Cell Reference in VBA? | Excel Programming | |||
dynamic external cell reference | Excel Worksheet Functions |