Error code 4605 which seems random in appearance - Excel 2010

I have a macro which uses a data from an excel file and auto populates a Word document (template). The macro copies text from certain cells and pastes them in the Word document at bookmark locations. However, some times Error code 4605 'This method or property is not available because the Clipboard is empty or not valid'. It almost seems random in where the error appears in the code. In addition I am having trouble with the Word app staying 'live' when the macro runs into an error and I cant seem to close it. This may have something to do we me using objWord and not appWord. But when I substitute objWord for appWord in the code below, it cant seem to find the bookmarks.
Any help with why the error is showing and how to fix it and then how to fix this terminating appWord issue.

Please Login or Register  to view this content.

Thanks

You might try sprinkling the DoEvents statement throughout your code. This releases resources to allow other applications to process their own queues and sometimes helps in situations like this.

Hi -

You can avoid copy and paste like;

Please Login or Register  to view this content.

event

event,

Your method certainly looks neater, however I get Run-time error '438': Object doesn't support this property or method. Any suggestions?

Storm85

mrice,
I shamelessly inserted half a dozen DoEvents, not really knowing how to use them properly (I assumed you simply put DoEvents interspersed with sections of code), but to no avail.... Same error immediately following a DoEvent.

Storm85

Hi -

Please post the codes where you get error '438'

event

Here you go:

Please Login or Register  to view this content.

Errors on the first .Bookmarks line.

Hi -

Post the word document as well.

event

event,

Sanitised document attached - thanks of the help.

Storm85

Hi -

this works for me;

Please Login or Register  to view this content.

event

Event,

It works a treat - no more error! Thank you for your time and expertise!

Storm85

Event,

It works a treat - no more error! Thank you for your time and expertise!

Storm85

Application.CutCopyMode = False
to clear your clipboard