View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Kenneth Hobson[_3_] Kenneth Hobson[_3_] is offline
external usenet poster
 
Posts: 14
Default 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.