That got it I had some little error I deleted and renetered and it is working
now
Thanks so much for your help!
Janice

"JE McGimpsey" wrote:

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