you could use a try...catch statement
Code:
'loop with worksheets
Try
   'your code
Catch ex as NullReferenceException

Catch ex as exception
    messagebox(ex.tostring) ' any other errors will be caught here
End Try
Next ' so that we move to the next sheet