you are perfectly right - how can what code would identify links to
workbooks which are closed?


i.e If Left(cell.Formula, 2) contains ":\" Then 'then select

thxs



Dave Peterson wrote:
And remember that not all formulas that link back to other workbooks start with
=[.



al007 wrote:

How can i make the code below select all cells in an active sheet
containg links to other (external) workbooks.

For Each cell In ActiveSheet.UsedRange
If Left(cell.Formula, 2) = "=[" Then 'then select
cells how to put selection code??

Thxs

--

Dave Peterson