Excel VBA 2010 - Copy to WB, RTE 1004 - That command cannot be used on multiple selections

Dear all,

I have an issue in my Code.
Sometimes it runs without issues, and sometimes not. I have not found the system.

I want to copy a named area in a sheet in current wb (XLSM) to a new workbook. As default, new wb's are xlsx.
I have read somewhere, that this error can occur, if the new wb is xls. But that is not the case.

In the worksheet there are som hidden columns, but these are not part if the named area.

When an issue occurs, it is the same place. Please see the red line below.

Please Login or Register  to view this content.

I hope you can shed som light over this issue - what am I doing wrong, and most exciting, why is this not a consequence error. Sometimes it works, sometimes not.

wbr
Benjamin

Hi, Sleever,

please have a read at Forum Rule #3 and add code-tags to your procedure as explained there.

Ciao,
Holger

Even easier to add code tags which make the code easier to read and to copy/paste.

Anyway, does this work?

Please Login or Register  to view this content.

Hi Norie,

yes - you are right. I have appologized to Holger.
I have tried your code. I get error her;

Please Login or Register  to view this content.

Excel error: Run-time errot '1004':
PasteSpecial method of Range class failed.


wbr
Ben

Hi, Ben,

you should try and work with objects throughout (I know: easy to tell and hard to do).

Maybe try

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Ciao,
Holger