![]() |
MSNStockQuote function gives #value
I have a file containing approx. 200 rows, each row starts with a Stock ID
and I use MSNStockQuotes to return the last price stock value. It works successfully for the first 100 or so rows, then randomly doesn't work for the second 100 rows. Maybe 30 or 40 of the last 100 rows doesn't work. If I change the stock id on each row that doesn't work and then hit backspace it works successfully. It seems very random on the 30 or 40 that don't work in the last 100 rows, and nearly everytime the first 100 rows work flawlessy. Anyone else seen this and have a fix for it? |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com