Downloading Data

  • Thread starter Thread starter Steve Almond
  • Start date Start date
S

Steve Almond

I have a VBA program, not written by me, which downloads stock prices from a
web site into an Excel spreadsheet.
It works perfectly, inserting the closing price of QQQ into cell C6.
There is a problem if I want to refer to this closing price from another
cell.
Even just transferring the price to cell D6 ("=C6"), causes the
program/Excel to crash and close down when I try to update the closing
price.
I can overcome this by downloading the prices in one step ("Update"), and
then transferring the price in a second step ("Transfer").
Is it possible to combine these two steps?

Steve
 
Have you tried using a VLOOKUP on a larger range than you would need to try and
get that data from Col C, eg:-

=VLOOKUP("QQQ",A1:C100",3,0)

Also, make sure that whatever cell you are referencing from is not within
whatever area will get blown away by refreshing the stock pull.
 
Ken,

The VLOOKUP trick works!
Strange how a direct reference causes problems, but sneaking up on it......

Thanks,

Steve
 
Back
Top