VBA Code for finding all external links in an Excel workbook

I accidentally left a couple of Debug.Print statements in there. Feel free to remove.

I found that it failed at the BadFileNameReport function. The line it failed on reads " For i = LBound(FileNames) To UBound(FileNames)"

I'd like your assistance with my post of finding links. You asked for a copy of the workbook but it's got a lot of parts I'd rather not share with the general population. Can I send directly to you and ask you to look at it?

There was a bug in the code. The code uses the presence of "[" to determine if an external file reference is present in a formula, but did not consider that this character is also used in table column references. The code has been updated in the original post.

There was another bug that I attribute to a VBA bug. Part of the code does a For loop to iterate through the FormatConditions collection in a worksheet. However, if the rule type is a "Graded Color Scale" rule, then an attempt to assign that rule from the collection to a variable of type FormatCondition raises a Type Mismatch error. I cannot think of any rationale for this. So I coded around it, using a Do/Loop instead of a For and testing for the xlColorScale type before trying the assignment.