D David McRitchie Oct 11, 2003 #2 Hi <insert missing name here>, You can use a User Defined Function such as one of a few that you can can find on my Build Table of Contents and Working with Hyperlinks page http://www.mvps.org/dmcritchie/excel/builotoc.htm#url Function HyperlinkAddress(cell) On Error Resume Next HyperlinkAddress = cell.Hyperlinks(1).Address if hyperlinkaddress = 0 then hyperlinkaddress = "" End Function usage: =HyperlinkAddress(A2) =personal.xls!HyperlinkAddress(A2) It is excellent for pasting your favorites into column A, and having Column B show the actual url. Instructions to install see http://www.mvps.org/dmcritchie/excel/getstarted.htm Bill Manville's solution, 2002-07-26, covers Excel links as well. http://google.com/[email protected]
Hi <insert missing name here>, You can use a User Defined Function such as one of a few that you can can find on my Build Table of Contents and Working with Hyperlinks page http://www.mvps.org/dmcritchie/excel/builotoc.htm#url Function HyperlinkAddress(cell) On Error Resume Next HyperlinkAddress = cell.Hyperlinks(1).Address if hyperlinkaddress = 0 then hyperlinkaddress = "" End Function usage: =HyperlinkAddress(A2) =personal.xls!HyperlinkAddress(A2) It is excellent for pasting your favorites into column A, and having Column B show the actual url. Instructions to install see http://www.mvps.org/dmcritchie/excel/getstarted.htm Bill Manville's solution, 2002-07-26, covers Excel links as well. http://google.com/[email protected]
