Hi Graham,

Try:

ActiveSheet.Hyperlinks.Delete




---
Regards.
Norman


"Graham H" wrote in message
...
I have downloaded a lot of text from a site and most of it is in
hyperlinks, but I just want the text. Is there a quick way to remove all
the hyperlinks in a worksheet or workbook. I appreciate I could loop round
all the cells but there is a lot of material and I just wondered if there
was something simpler. I would value any help.

Regards
Graham