Hi, I have a long module written to copy data from an excel sheet to a new word document.
I sporadically get the error message saying:
"run-time error 4605
This method or property is not available because the clipboard is empty or not available"
Stepping into debugger it stops here: "wdApp.Selection.Paste"
It seems to occur randomly (different places, different times and sometimes runs with no issues).
I have tried adding DoEvents and tried to use Application.CutCopyMode = False but still occurs.
Does anyone have any other ideas how to stop this error occuring.
Bookmarks