As allready mentioned the Code "On Error resume Next" says to the System that the actual Error is to ignore and the System goes automaticly to the next Code-Line.
What you can do now is to code an Error-Handling after each line where an Error could happen. This could look like :
If Err.Number <> 0 Then
myMessage = "Error " & CStr(Err.Number) & " " & Err.Description
' do something with this info
Err.Clear
Exit Sub
End If
This gives you the ability to see where the Error occures and perhaps also what kind of Error it is ...
The Rest is up to you ...