R
Robert P. Stearns
Is there a way to select a range and delete hyperlinks instead of doing it
one cell at a time?
one cell at a time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin H. Stecyk
"Robert P. Stearns" ...
Modified from John Walkenbach's site...
http://www.j-walk.com/ss/excel/usertips/tip031.htm
Sub ZapHyperlinks()
Selection.Hyperlinks.Delete
End SubHope that helps.
Regards,
Kevin
Is there a way to select a range and delete hyperlinks instead of doing it
one cell at a time?
Modified from John Walkenbach's site...
http://www.j-walk.com/ss/excel/usertips/tip031.htm
Sub ZapHyperlinks()
Selection.Hyperlinks.Delete
End SubHope that helps.
Regards,
Kevin
R
Robert P. Stearns
Works great! Thanks.
Kevin H. Stecyk said:"Robert P. Stearns" ...
Modified from John Walkenbach's site...
http://www.j-walk.com/ss/excel/usertips/tip031.htm
Sub ZapHyperlinks()
Selection.Hyperlinks.Delete
End SubHope that helps.
Regards,
Kevin
K
Kevin H. Stecyk
Robert,
Glad it worked well for you.
Regards,
Kevin
"Robert P. Stearns"
Glad it worked well for you.
Regards,
Kevin
"Robert P. Stearns"