VBA to remove hyperlink?
 

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

Thanks,

Keith

VBA to remove hyperlink?
 

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

VBA to remove hyperlink?
 

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