Are the hyperlinks created using the =HYPERLINK function?

If so, the following won't work

Sub DelAllHyperlinks()
ActiveSheet.HyperLinks.Delete
End Sub


Gord Dibben MS Excel MVP

On Fri, 12 Sep 2008 15:19:01 -0700, Phia
wrote:

I pull metrics on a weekly basis, which include the hyperlink format in the
worksheet. I need to remove the hyperlink in order to remove the headache of
someone reading the report and accidently clicking on the hyperlink and going
no-where.

Right now I manually select each cell in the same column and right mouse
click to remove each hyperlink. If my report is over 100+ rows in length,
this can get tedious and take a long time. So, how do I create a vb
program/macro that will allow me to select the first cell in the column,
remove the hyperlink format, then select the next cell, and continue clearing
the format until there is no more entries in the column?

I've tried to use Range, but there doesn't appear to be a clear format
parameter available. Any help is very much appreciated!