I think it's because the code above doesn't put the http:// in the hyperlink, but when I manually right click the cell, click hyperlink, CTRL C the 'text to display' and CTRL V into the 'hyperlink', it DOES put http:// in front. How can i incorporate this into the code above? Thanks.