STEVE BELL wrote:
The text on the clipboard is coming from a copied source.
Yes, but it's coming from another program.

you could just set a string variable = to the source.
(and this avoids selecting, copying, pasting)

that's what I alluded to when I said:

Replace the text with a cell reference, a text reference, a result
from an InputBox or form, or a variable.


Or have I gotton confused?
No, you were clear, but I solved it, I first paste the text to a cell
and read it in a variable exactly as you told me. I was only very
surprised that I could not use the Paste command as I am used for a long
time with Word.

But thank you for sending me to this direction.

Danny