Have you been changing the programmatic name (i.e. the one shown in
parentheses in the hirerachy under MicrosoftExcelObjects in the VB
Explorer) of any of the worksheets, by any chance? May be
irrelevant, but I've heard that this is a dangerous thing to do (can
produce unpredictable results). I'm not sure whether this affects
the indexing. When you say moved from index 2 to index 8, did you
just drag the tab along in theExcelwindow to re-order the sheets, or
did you do anything in the VBE?

I do change the name of the worksheet that was copied, if that's what
you mean. But that shouldn't affect the copy, which is happening
first. When I moved the sheet, I just dragged the tab.

No, I meant changed the *programmatic* name of any of the worksheets (which
you can only do in the VBE or via VBA) prior to the copy. I don't mean
change the "visible" name on the worksheet tab... I'm clutching at straws
here. Tried copying the sheet(s) and code to a blank fresh workbook and
trying it there?