Excel VBA Copy and Paste Rows with Variable Cell Ranges) :    I have the code Attached:

I get runtime error 1004 on the first xsheet.range, and I am sure the error would occur on the 2 following, in the For Loop.  CPC has Value and so does row.  In worked in a test sheet but there was no loop.  No I lost the test sheet.

I would appreciate any help possible.

All the best Jim[![Snipit Code][1]][1]

    

  

         


  [1]: https://i.stack.imgur.com/o8vGv.png