Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
"Dave" wrote in message
... An outside application exports data to an Excel spreadsheet, but all the numbers (part numbers in this case) are created as hyperlinks. My spreadsheet can contain hundreds of numbers. Is there any way I can remove the hyperlinks en masse rather than one by one? I can't change the program that creates the spreadsheet. Yes Dave, with a simple macro: Sub Macro1() ActiveSheet.Hyperlinks.Delete End Sub Rgds, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random hyperlinks everywhere! | Excel Discussion (Misc queries) | |||
remove all Hyperlinks at one time. | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |