Hey SamT,

Thank you so much for your help, I really appreciated.

I’ve been testing your code this morning and we are getting much closer now, the code it’s copying the first column successfully but not the rest of the columns of the name range .

Here is an image of how the name range look like in both workbooks.


Untitled1.jpg

Everything highlighted in yellow is part of the discontinuous name range.

So the code is copying column I without any problem but K-O , Q-R are not being copied
How can include the rest of the columns?

Thank you again Sam,

Lotuxel, I don’t fully understand your code to test it , doesn’t seem to be able to copy a range from one workbook to another , can you clarify ?