| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Hyperlinks in another column
I have a column containing 2500 items that have hyperlinks. I would
like to set up another column that will show the hyperlink values. I know this should be easy but I can't figure it out. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Showing Hyperlinks in another column
Sub ShowLinks()
For Each hlink In ActiveSheet.Hyperlinks hlink.Parent.Offset(0, 1).Value = hlink.Address & " " & hlink.SubAddress Next End Sub -- Regards, Tom Ogilvy wrote in message ups.com... I have a column containing 2500 items that have hyperlinks. I would like to set up another column that will show the hyperlink values. I know this should be easy but I can't figure it out. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Showing Hyperlinks in another column
That did it. Thanks a lot!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding a column of hyperlinks behind a column of numbers | New Users to Excel | |||
| Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f | Excel Discussion (Misc queries) | |||
| Showing Last Value in a column | Excel Discussion (Misc queries) | |||
| Importing e-mail addresses not showing as hyperlinks | New Users to Excel | |||
| Showing the column of current day | Excel Worksheet Functions | |||
Linear Mode
