Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I display hyperlink in Excel cell?
I have a spreadsheet with 100's of hyperlinks but I want to display the links
in the workbook, how do I display the hyperlink in each cell? Is there a way to run a macro or convert the cell to show the hyperlink? |
#2
|
|||
|
|||
Also, when I use the code in provided in another post I get "#name?" in the
cell, what am I doing wrong? "Erich" wrote: I have a spreadsheet with 100's of hyperlinks but I want to display the links in the workbook, how do I display the hyperlink in each cell? Is there a way to run a macro or convert the cell to show the hyperlink? |
#3
|
|||
|
|||
I probably means that you have the formula in your personal.xls
and did not include the workbook name with the formula name. http://www.mvps.org/dmcritchie/excel...perlinkaddress Function HyperlinkAddress(cell) As String If cell.Hyperlinks.Count 0 Then _ HyperlinkAddress = cell.Hyperlinks(1).Address End Function =Hyperlinkaddress(A1) =personal.xls!hyperlinkaddress(A1) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Erich" wrote in message ... Also, when I use the code in provided in another post I get "#name?" in the cell, what am I doing wrong? "Erich" wrote: I have a spreadsheet with 100's of hyperlinks but I want to display the links in the workbook, how do I display the hyperlink in each cell? Is there a way to run a macro or convert the cell to show the hyperlink? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF command in Excel | Excel Discussion (Misc queries) | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
Display a pix from a URL in a Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |