Union Range copy code works first time but generates RunTime Error 1004 on second bloc

[Ochimus]

Code below copies and transposes non-contiguous data from ProdSheet Cols D - V to the relevant row in Col GM on the Database perfectly:

Please Login or Register  to view this content.

But adding a second "cycle" repeating the same process for a different bloc of data produces a RunTime 1004 Error - Method 'Range' of object'_Global' failed

Please Login or Register  to view this content.

Hope someone can see the problem?

All solutions, suggestions and alternatives welcome as ever,

Ochimus