Finding Cells with Links in Excel

[CandyMan]

Heyas

Anyone know how I can run through a workbook in Excel 2k and test each cell if its value is a link to another workbook??

Have broken links and the file is too big to find it.

Deleting the links is the last option

If I could somehow findthe initial 2 chars of the link function ie =[
Then I think Im half way there but how can I compare a function syntax instead of the actual value visible in the Cell??

Many thanks for any insight

CandyMan

NEVER MIND

If Left(CStr(ActiveCell.Formula), 2) = "=[" Then
MsgBox "Match"
End If

Can start with this...