VBA fails every other time

[Will B]

Good morning all.

I have 2 routines, one is called from the other dependent on the outcome of a msg box answer.

I have this code replicated 4 times, for 4 different msg boxes and 4 different sources and sheets. I sometimes get the warning box on failure, with the useful text "400". Please find below the routines.

Please Login or Register  to view this content.

This sits in the worksheet vba.

Then...

Please Login or Register  to view this content.

This sits in a module

It fails on the paste to dest1 the second time round, without fail. I cannot work out why it would work, then not and repeat this. If anyone has any ideas, I would greatly appreciate their input!

Many thanks

[Mallycat]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Will B]

Sample Workbook.xlsm

Please find attached workbook example. The button copies and pastes data from source to destination, as as you can see only works every other time. Thanks very much for anyone taking a look at this

[Will B]

Can anyone help at all its doing my swede!