Good afternoon !

As you can use Copy method only on object so obviously not on a string variable !

See the VBA inner help for PutInClipboard method for example or crystal clear explain your need …