In retrieving stock info from the internet there is a problem if a user selects a date that was prior to the existence of the stock. Currently, if that happens, the user just gets blank cells.
The attached image shows 2 printscreens.
The top image shows a table that isn't a problem.
The bottom image shows an attempt to retrieve info 2 years prior to the existence of data and Yahoo says data is unavailable.
What code can I insert that will alert a user that they need to pick a different date? The alert can be something as simple as inserting XXXX instead of a stock price. Definitely not looking for a fancy solution.
Thanks all!!
StkErr.jpg
Here is my code:
Bookmarks