VBA script causes clipboard to be lost
Did you try this after a copy?
Application.CutCopyMode=False
Two other concepts could be used to work around the problem. Both use a
scratchpad method.
1. Copy to and paste from the a UserForm's Spreadsheet control.
2. Copy to and paste from a scratch xls.
I have used method (1) to hold multiple copies as plain text in Userform
Textbox controls.
|