Add error check and write not found item to a worksheet

This macro pulls a stock symbol from the first column of the "ActiveStockSymbols" worksheet. It then goes to the Internet/BarChart.com an gets the historical stock data for the symbol, and inserts the data into the "BackTest" worksheet for processing...… Works great so far! It steps through the list UNTIL it acquires a stock symbol that is no longer active in the stock market. The process comes to a grinding halt. I need to add an error checking routine to catch those symbols, add them to the 1st column in a worksheet called "InvalidStockSymbols" and then get the next symbol from the "ActiveStockSymbols" worksheet and continue through the entire list.

I apologize for the comment lines in the script, but that is the only way I can remember what I was trying to have that section of code do. I have no clue as to how to insert the proper code to accomplish this. This may not be the most efficient code, but it does work.

Any assistance will GREATLY be appreciated.
Don

Please Login or Register  to view this content.

Sorry, I don't know what a stock symbol is and you've not provided any examples.

It sounds as though you need to look at a way to deal with the Errors though which will allow you to capture the rogue symbol, you'd probably be looking at "On Error"

Take a look at this link and see if it helps you out any; http://www.cpearson.com/excel/errorhandling.htm

If you need more help then post back with an example of the stock symbols