Super weird issue with VBA Range replication

魔鬼肌肉人

xlsheet_finance.Range ("A1: R4, A6: R6, A10: R10"). Copy
Workbooks.Add
Sheets ("sheet1"). Paste

The goal you want to achieve: Copy the first to fourth, sixth, and tenth lines of the current work area xlsheet_finance to the new worksheet1 work area of ​​the Excel file.

Problem encountered: After running, all lines from line 1 to line 10 were copied. If it is copied to a different workspace of the same EXCEL file as xlsheet_finance, there is no problem. It is the strange phenomenon that all ten lines are copied when it is copied to an external Excel file.

Have you encountered this problem?

星空再现

It seems that discontinuous areas should be copied separately, otherwise errors may occur

魔鬼肌肉人

But I tried copying discontinuous areas in different workspaces of the same EXCEL file, everything works fine

The problem is that when copying between different EXCEL files, it is always copied to a continuous area by default

Depressed, if this function cannot be implemented now, it will make my VBA automatic program one less bright spot ~~

Everyone, please help me to investigate, do you need to pay special attention to it?

Microsoft's Office should not be so mentally retarded?

ybirdl

Another easy way is to copy the first line to the tenth line, and then delete the lines you do n’t need.

魔鬼肌肉人

After I copy to a new file, if I delete the lines that I don’t need, there will be no continuity in the middle, and it will be ugly for users to open the document

And the target rows I copied are all dynamic, and I can’t know in advance which ones I don’t need ^_^

Think again, why do I use VBA code to copy from one document to another document and copy the intermediate lines that I don’t need? There is no such problem in a document, VBA code can normally copy and paste discontinuous line records ~~