How can I get rid of the hyperlinks
a simple way to remove all hyperlinks in a sheet
insert a module and paste this sub
Sub delHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
"Just Me" wrote:
I'm making a workbook for my credit card statements so I can track expenses,
when I copy and paste from my Credit Cards online site the column that shows
the dollar amount pastes onto my worksheet as a hyperlink. How can I change
the whole column to just a dollae figure?
Thanks
|