How to copy a range from 1 workbook to a new workbook and avoid subscript out of range error

[nando88]

I am trying to copy a range from 1 workbook to a new workbook, but I keep getting subscript out of range and I don't know how to fix it.
The workbook still has no name, since I still have not saved it, since I am going to save it until all my code executes.
Any help will be greatly apperciated.
Thanks in advance.

 

[johnnyL]

What is the code that are you trying to use?