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...


Code:
--------------------

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.


--
ph8
------------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=517217