Hey good stuff! Thanks for that solution, it's not slick, but it works!

"Excel_Geek" wrote:


You can download the Excel 2003/2002 Add-in: MSN Money Stock Quotes:

http://tinyurl.com/dw948

This won't automatically create a smart tag for GM, for example. But
you can use the "Insert Stock Quotes" function on the newly installed
toolbar to create a quote for GM, which will drop that quote onto the
sheet where you specify. Then you can copy and paste the cell with
"GM" in it (now with a smart tag) to where ever else you might need it,
and the smart tag will go with it.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=400137