Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking a Reference Error
Hello
The code below is use to find any broken references and remove them. I have proven it finds any 'MISSING' references but cannot remove them. It gives error -2147319779 "Object Library not recognised" Dim theRef As Variant, i As Long On Error GoTo errorhandler: For i = Application.VBE.activeVBProject.References.Count To 1 Step -1 Set theRef = Application.VBE.activeVBProject.References.Item(i) If theRef.IsBroken = True Then Application.VBE.activeVBProject.References.Remove (theRef) End If Next i Anyone got any ideas on this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking Link to a Circular Reference with Macro | Excel Programming | |||
Breaking links leaving invalid reference #REF! in cell | Excel Discussion (Misc queries) | |||
error bars when breaking the y-axis | Charts and Charting in Excel | |||
Reference Error | Excel Programming | |||
VBA reference error | Excel Programming |