VBA referencing worksheet by index, not by name.

Hello experts,

The code I wrote copies data between two workbooks, each with worksheets numbered 1:32 with some additional worksheets as well.
I want it to copy data from sheet "1" from Workbook-A into sheet "1" of workbook-B and then to repeat the process for all 32 workbooks.

As the codes is now, it is referencing sheets by index - not by name. In workbook-B, sheet '1' is not the first tab. I need it to reference the name of the sheet (not the index) What am I doing wrong?


Dim NextESheet As String

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Regards, TMS

Trevor, any reason not to condense it down to the single command:

Please Login or Register  to view this content.

Hello TMS,

Actually, the code works well both ways. Thanks!!
(my previous report here that there was a problem was not true). Thanks again!

Nope, none at all.

I've just done a lot where I've wanted to copy and format and stuff and the With ... End With makes that neater.

Just got carried away

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.

You're welcome.