Dave F 's suggestion is right on. It's a nice macro.
I downloaded it and am using it.
Spreadsheet can easily be reformatted to suit the user.
Now does anyone know where to find a list of all market symbols?

"Dave F" wrote in message
...
I've used one posted he http://gallery.yahoo.com/apps/2260

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Chris" wrote:

Is there anyway to setup Excel to retrieve stock quotes. Could anyone
write a
macro or point me in the right direction.

Thanks