Hi Charles,


This works nicely, too. I was able to modify your code so the table, sans hypertext, is copied to the clipboard. Thank you!


The reason I want to strip hypertext from the clipboard, rather than from the table, is that the text, after it's copied, doesn't get pasted. I assign whatever is in the clipboard to a text variable, and parse it. But I know nothing about the metadata associated with the hypertext, so I can't delete it. I was hoping there might be a way to unlink hypertext from the clipboard before I assign the clipboard to a variable.

There may well be a way. However, I do not know it and suggested a workaround.

1. After copying, create a new blank document.
2. Paste into that document.
3. Run the macro to strip out the hyperlinks.
4. Copy the modified text from the new document.
5. Close the new document without saving.

At this point, the clipboard contains the text without the hyperlinks.