On Error Resume Next has the effect of ignoring errors and continuing on to
the next command. It can be very useful, but it has to be used with caution,
resetting as a minimum with On Error Goto 0, at some point, otherwise all
errors will get ignored, even those you don't.

Which error do you want to ignore, and why?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ph8" wrote in message
...

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