VBA Excel Hyperlinks

[Lost User]

Hi I am opening up a workbook from Microsoft Outlook an entering a hyperlink to an email message into one of the cells. At first I was using the Hyperlink function but i keep getting a dialog telling me this function is not supported (the function works though as the hyperlink apppears and is functioning when i open the workbook afterwards). I tried to get round this by using file:///filename - this appears as standard text in the cell until i double click on it and then click away - at this point it turns into a hyperlink. I have tried using file:/// and then programatically selecting the cell and moving away but to no avail. Does any one know of a suitable way of doing what I want without thest issues? Thanks Dan

[Duane in Japan]

Dont know if this will help any but I used to Hyperlink thousands of cells down column A with a loop. Here is a piece. ActiveSheet.Hyperlink.Add Anchor:=Sheet1.cells(a,1), _ Address:=Sheet1.cells(a,1).value, _ TextToDiaplay:=Sheet1.cells(a,1).value Then it would loop to A2, A3 and so on down the line till it errored cause I did not know how to stop the loop. (a,1) is column A and row 1, I think, maybe first row and column 1. I think row is mentioned before column??? This stated whatever text was in cell A1, hyperlink it, yes in my case it was a web address, this was several years ago. Now I use a third party macro recorder, not VBA, and it double clicks on the cell as you mentioned and creates the hyperlink through its double click leftmouseclick code. Hope the snippit above gives you an idea, check the help file if needed.