View Single Post
 
Old 03-01-2020, 12:16 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by eduzs View Post
If your code is not running as expected, it is not recommended to use "On Error Resume Next", cause this will prevent you from find the error source.
That isn't going to help it run correctly. The only issue with it's use in the OP's code is that it isn't followed by an appropriately-located 'On Error Goto 0' at a point from which errors should no longer be skipped over. If the OP was simply to delete 'On Error Resume Next', that would likely cause the code to stop exactly where one wouldn't want it to.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote