Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Differentiating Text from Hyperlink Data type
refer to the hyperlinks
Sub GetAddress() Dim hlink As Hyperlink Dim rng As Range For Each hlink In ActiveSheet.Hyperlinks Set rng = hlink.Range rng.Offset(0, 1).Value = hlink.Address Next End Sub -- Regards, Tom Ogilvy "Sathya" wrote in message ... Hi Guys, I have a little problem using hyperlinks in Excel worksheets. I have a column with text as well as hyperlinks, I need to only extract the hyperlink addresses to another column The macro i wrote fails as it tries to do the operation on text too. Is there a function to differentiate between text and a hyperlink? Any help would be appreciated Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formating cell with TEXT data type | Excel Discussion (Misc queries) | |||
Differentiating data by year into columns | Excel Worksheet Functions | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |