Run Time Error 9: Subscript Out of Range when Copy and Paste between Workbooks

Hello,

I'm not finished, but I'm trying to modify code that will copy data 600 rows at a time and then paste it in a new workbook each time. I will eventually try to make it name each workbook with an incremental number after the file name, or I will just let the user type the file name in an input box like I have below.

Right now I get Run Time Error 9: Subscript Out of Range on the line below:

Please Login or Register  to view this content.

(I've also tried using

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

as in the original code.)

Question: 1) What is the issue b/c I've looked at code that uses Range.Copy Destination: between workbooks:

Do I need to activate the nrenwb with nrenwb.Activate? I had to add

Please Login or Register  to view this content.

b/c I got the same Run Time Error 9 highlighting the same line above. As I say, I don't see why b/c won't

Please Login or Register  to view this content.

activate the nrenwb workbook?

2) Also, I've seen on the internet that if you have a path in the filename you can get this error, but

Please Login or Register  to view this content.

makes sure the variable, nrenwb, just gives the filename entered by the user with '.csv', doesn't it? Though in the locals window the Full Name does have a path.

I would appreciate any help debugging this error. Thank you.

Please Login or Register  to view this content.

Source: http://stackoverflow.com/questions/3...-workbook-loop

Untested but try change to

Please Login or Register  to view this content.

Hello jindon,

Thank you for your reply. I tried using the code and it still stops on the same line with the same error even after you changed it to Sheets(1):

Please Login or Register  to view this content.

I would appreciate any input from you or others to help debug. Thank you, again.

It might be

Please Login or Register  to view this content.