Quote Originally Posted by simora View Post
In Excel 2007, so an xls file, How to select the ActiveSheet plus the two sheets on the right, ( 3 Sheets ) and copy them to the end of the visible worksheets using VBA code.
Cant Hardcode the Sheet Names because they change.
Are the visible worksheets in the ActiveWorkbook with the ActiveSheet?

What happens if the ActiveSheet is so far to the right that it doesn't have 2 more sheets?

So ...

Sheet20
Sheet15
Sheet10 <<< ActiveWorksheet
Sheet5
Sheet6 <<<<< Hidden
Sheet7
Sheet8

Ends up like

Sheet20
Sheet15
Sheet6 <<< hidden
Sheet8
Sheet10 <<< ActiveWorksheet
Sheet5
Sheet7