Is there a way for Excel to skip reporting an error if a function doesn't work? More specifically I once saw the use of the command "on error resume next" which as it stands I have very little clue as to what it does.

Regardless...

Private Sub Refresh_Click()
    Dim i As Integer
    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
    
    For i = 10 To 39
        addComment (Cells(i, "B"))
    Next i
End Sub
This is my code. I receive an "Method 'UpdateLink' of object '_Workbook' failed" error when the source and the destination sheets are both open and the "refresh" button is clicked. This will very rarely happen when the users are actually using the files, but in the rare case that it does I'd rather they be able to still update links without receiving the error.

Is there a way to either ignore the error, or a different way to update the links which would avoid the error completely?

THanks in advanced.