Run-time error 1004 when trying to resize a multi area range object

[barbosajulio77]

Thank you.

I am not good in VBA how to i add this to my complete code so it works,

Set rngDst = wkbDst.Worksheets("STATEMENT").Range("A17:C17, E17")

---

Sorry ignore my previous reply.

What I meant is how to add your working suggestions to my code that the range

("A17:C17, E17")

works?

Thank you