I have a worksheet that has info that was ported from a pdf file. The cell
has a reference that would give additional info. I do not need it there.
How do I remove reference to additional info?
It depends on the nature of the reference. If the reference is a hyperlink,
then this tiny macro will remove it:
Sub format()
Selection.Hyperlinks.Delete
end sub
Just select the cell(s) and run the macro
--
Gary's Studentquot;stayathome working girlquot; wrote:
gt; I have a worksheet that has info that was ported from a pdf file. The cell
gt; has a reference that would give additional info. I do not need it there.
gt; How do I remove reference to additional info?
has a reference that would give additional info. I do not need it there.
How do I remove reference to additional info?
It depends on the nature of the reference. If the reference is a hyperlink,
then this tiny macro will remove it:
Sub format()
Selection.Hyperlinks.Delete
end sub
Just select the cell(s) and run the macro
--
Gary's Studentquot;stayathome working girlquot; wrote:
gt; I have a worksheet that has info that was ported from a pdf file. The cell
gt; has a reference that would give additional info. I do not need it there.
gt; How do I remove reference to additional info?
文章標籤
全站熱搜
