Did you try it either of the macros in item 4?

In article ,
Janice wrote:

I think this is 'backwards'of what I want. That data that I am copying is
in table form. Some of the 'cells' in the copy are hyperlinks. When I paste
it I want to disable the hyperlink.Thanks