1) The order the sheets exist in the workbook is irrelevant, the array is addressing them by name so it can find them wherever they may be. Whatever you did with the sheets fixed the spelling errors is most likely what occurred, or the wrong workbook was "active" when you tested... I do that a lot.
2) When that error occurs, what is the value of LR? What is the actual LR of visible data on the current ws being parsed?
Click DEBUG
Press Ctrl-G to open the Immediate window
Enter these commands:
? ws.Name
? LR
No chance I can look at what you're looking at?
Bookmarks