Error in macro when auto-pasting code

[Reapz]

Hey all,

I'm new to VBA but have had it working well for me until the other night when a user complained that when he ran a macro, it came up with the error "Paste method of Worksheet class failed". I should note that this function has worked time and time again, so I'm lost as to why it just started. I also found tonnes of answers with a Google search but they were all relative to that persons code.

So this is the code I am using to paste from the clipboard into another tabbed worksheet (apologies if the code is horrible) - Also the part where the debugger stops (and highlights) is ActiveSheet.Paste

Please Login or Register  to view this content.

Thank you for any help!

[Bernie Deitrick]

Did you add this line recently?

Please Login or Register  to view this content.

Any action other than selecting will clear the clipboard.

[Reapz]

Did you add this line recently?

Please Login or Register  to view this content.

Any action other than selecting will clear the clipboard.

Yes I added that around two weeks ago and it seemed to be working perfectly prior to just the other day. I need the data that was previously in that range to be cleared before the data in a separate workbook is pasted.. Is that possible?

Thanks for your help.

[Bernie Deitrick]

Sure - the best way is to clear it first before copying, but to not change your workflow, we can check after the paste for the cells that were not pasted into....

Please Login or Register  to view this content.

[Norie]

I think someone here might have a similar problem.

[Reapz]

Sure - the best way is to clear it first before copying, but to not change your workflow, we can check after the paste for the cells that were not pasted into....

Please Login or Register  to view this content.

Thank you, that worked perfectly, enjoy some +rep! So can anyone explain to me why this would have worked for the past few months, but then all of a sudden it became a problem? Or at least can anyone confirm my understanding of this - that the code I had also cleared the clipboard, thus when it went to paste there was nothing to actually paste.. right?

Which brings me back to being confused because it worked for so long..

Anyway thanks again!

I think someone here might have a similar problem.

Oops I must have posted the thread twice by accident? My bad, sorry!

[Bernie Deitrick]

The only reason that I can think of that could have led you to think the macro worked is that you have multiple versions of the macro, some changed and some not, in different versions of the workbook. The .Clear command will always clear the clipboard.

[Reapz]

The only reason that I can think of that could have led you to think the macro worked is that you have multiple versions of the macro, some changed and some not, in different versions of the workbook. The .Clear command will always clear the clipboard.

Hmmm strange. I will have to have a play around and see what I can find.

Truly appreciate the help, Bernie! Cheers mate!