View Single Post
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"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