Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links,microsoft.public.excel.programming
|
|||
|
|||
Excel losing hyperlinks when I sort the worksheet
Hi,
(Sorry for the crossposting, but I felt this post applied to both newsgroups...assuming excel.links means "hyperlinks") I have an Excel worksheet with about 1000 rows. One of the columns contains hyperlinks. The text of the hyperlink is the URL - IOW the displayed text and hyperlink are the same. When I add new data to the worksheet, I need to sort it by a particular column. When I do so, some of the hyperlinks are removed. The text is still blue, underlined, proper font, but the hyperlink is gone (it's a very hard problem to find). This happens in both Excel 2003 and Excel 2007. Has anyone ever seen this behavior, and know of a workaround? Alternatively, is there an Excel function that will create a hyperlink from the text in a cell? If so, can you also provide the VB code to: * spin thru all the rows in the workbook * for the text in column <whatever, apply the <function to the cell value to convert it to a hyperlink Sorry, while I'm a programmer and can follow and modify VB code, I'm not fluent in VB so find it hard to create from scratch. Thanks for the help! Cheers, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel losing hyperlinks when I sort the worksheet | Links and Linking in Excel | |||
Losing hyperlinks in advancedfilter copy to location | Excel Programming | |||
Losing hyperlinks | Excel Discussion (Misc queries) | |||
Copying HTML into Excel Losing Hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks.Delete without losing formatting? | Excel Programming |