software

The workaround (multiply range by quot;1quot;) is rediculous and impacts cells in
range with other types of formating.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

You can use the following VBA code:

Sub AAA()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Delete
Next HL
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Mark Bquot; lt;Mark gt; wrote in message
...
gt; The workaround (multiply range by quot;1quot;) is rediculous and
gt; impacts cells in
gt; range with other types of formating.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds
gt; to the
gt; suggestions with the most votes. To vote for this suggestion,
gt; click the quot;I
gt; Agreequot; button in the message pane. If you do not see the
gt; button, follow this
gt; link to open the suggestion in the Microsoft Web-based
gt; Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc