Code to find formulas that reference other workbooks?
I have a workbook that (apparently) contains references to another workbook.
Upon opening, I get the usual "do you wanna update links?" window, to which
I say yes. I have no idea WHERE these references are (large spreadsheet -
not completely create by yours truly). My question is this: is there a
simple VBA code to help me pinpoint exactly where the external references
are located so I can modify them?
Thanks guys (and gals!),
Keith
|