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