Copy two ranges from one workbook to another

[philips]

Hi all,
I would really appreciate help with the code below, shouldn't be very challenging for you guys, I'm just a beginner though.
I've been trying to to create a macro that would do the following:
1. Copy the range A2:AT10000 from one workbook to the first sheet of a new workbook.
2. Go back to the initial workbook and select range A6:HF10000 in the sheet with codename: Sheet11
3. Paste the selection to a newly added worksheet (sheet 2) of the workbook created in step 1

I am getting run time error 424 and when debugging, the highlighted line is:

Please Login or Register  to view this content.

Thanks for your time!

Please Login or Register  to view this content.

[HaHoBe]

Hi, philips,

maybe use either of these two approaches:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is there really data in all these cells or could UsedRange be used to only copy that range?

Ciao,
Holger