Macro quitting before completion

I am running a macro that grabs info from Yahoo. The macro is working fine except when it encounters two particular situations.

The macro is designed to grab a closing stock price for a date specified for a list of Symbols in column A and the date in column B. The closing price is then displayed in column D.

The problems (there are two that I found) I am running into is that when the Macro encounters a symbol in Column A and is not recognized, an error message pops up and the macro stops altogether. I want the macro to continue to run down the list but I can't figure out where in the macro it is stopping and, more importantly, how to make it continue. Any help is appreciated. I have attached a copy of file if needed (if opened, you can see it stops working after row 11). Thanks

The other issue, which is related to the first issue somewhat is if the macro runs into an invalid date in column B (e.g. the user may enter a date that is for a Saturday or Sunday in which Yahoo would not have any data). This also causes the macro to stop.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Put Resume at the end of your error handler.

Set breakpoints; what if the error is none of those you catch?

Please Login or Register  to view this content.