Downloading Data

[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

 

[Ken Wright]

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.

 

[Steve Almond]

Ken,

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

Thanks,

Steve

 

[Ken Wright]

LOl - Always more than one way to skin a cat