I wrote a macro to copy data from multiple worksheets on a spreadsheet that I
receive each day. If there is no data to report for one of the worksheets the
worksheet is not included in the spreadsheet that I receive. Therefore I used
multiple On Error statements in my macro (one for each worksheet that may be
missing) to jump to an error handling section for each worksheet to handle
the missing sheet, then jump back into my macro at the section that deals
with the data on the next sheet. The problem that I have is that if more than
one worksheet is missing from the spreadsheet that I receive, then my macro
stops with an error on the second missing worksheet. I have tried inserting
On Error GoTo 0 statements to reset my error handling but that does not help.
What am I doing wrong?