VBA to remove hyperlink?

How can I use VBA to remove a hyperlink from a cell, while retaining the
cell content?

Thanks,

Keith

sub hypergone()
Selection.Hyperlinks.Delete
end sub

Just select the cells you want to clean first and then run the macro.

God Luck
--
Gary's Student


"keithb" wrote:

> How can I use VBA to remove a hyperlink from a cell, while retaining the
> cell content?
>
> Thanks,
>
> Keith
>
>
>

You've got another very similar answer in .misc.

keithb wrote:
>
> How can I use VBA to remove a hyperlink from a cell, while retaining the
> cell content?
>
> Thanks,
>
> Keith

--

Dave Peterson