<div>
Guys, both solutions worked perfectly and have the exact timestamp when posted. So the best option is to split the points equally. Many thanks for your help.<br />
Sam
</div>


Guys, both solutions worked perfectly and have the exact timestamp when posted. So the best option is to split the points equally. Many thanks for your help.
Sam

<div>
Sub RemoveHyperlinks()<br />
ActiveSheet.Hyperlinks.Del<wbr />ete<br />
End Sub<br />
<br />
will also do it.<br />
Regards,<br />
Rory
</div>


Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

will also do it.
Regards,
Rory

<div>
A little add-on:<br />
If you want to delete the text as well it is done with:<br />
<br />
Sub RemoveHyperlinks()<br />
<br />
For Each hl In ActiveSheet.Hyperlinks<br />
<br />
&nbsp; &nbsp; Range(hl.Range.Address).Cl<wbr />earContent<wbr />s<br />
<br />
Next hl<br />
<br />
End Sub<br />
<br />
Claus Henriksen
</div>


A little add-on:
If you want to delete the text as well it is done with:

Sub RemoveHyperlinks()

For Each hl In ActiveSheet.Hyperlinks

    Range(hl.Range.Address).ClearContents

Next hl

End Sub

Claus Henriksen

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in the spreadsheet. Thanks<br />
Sam
</div>
</div>


Hi Experts,
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in the spreadsheet. Thanks
Sam

Macro for removing hyperlinks from spreadsheet

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.