Say you have an excel file with stocks on it..
in the first list..

MSFT News
WIN.to News
JBOH News
AMTD News

all in the first row.. I want to make.... a link say
www.stockquotes.com/bla/bla/symbol= (cell) /bla/bla.htm
So I can see the news.

how would I make it auto fill one of the stocks above.. and be blue
clickable?

In query you can make it so it refers to the link as what evers in cel
say A1 , it'll place it in the link. But I dont want the info to be
pulled to the excel page, I want to be taken to the browser to see the
news.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/