Example: Removing Broken References.... but I first have to disable the error messages... Dim theRef As Variant, i As Long On Error Resume Next For i = 1 To Application.References.Count 'Remove any missing references Set theRef = Application.References.Item(i) If theRef.IsBroken = True Then Application.References.Remove (theRef) End If Next i
|Excel Error "Could not load an object because it is not available on this machine"||6||18|
|help with changing the VBA to ignore if sheet exists||6||18|
|Excel range I cannot find||8||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!