Hi there,

I have a workbook where sheet #10 is visible, but sheets 11-13 are xlHidden. I invoke macros that are intended to copy either sheet 11, 12, or 13 and put them at the end of the at workbook (sheets.count, would usually be sheet #14). For whatever reason, if the last worksheet is invisible (e.g. 13 usually is), it pastes the worksheet after the last visible worksheet (in this case after sheet 10). So in short, instead of copying sheet 12 and making the copy sheet 14, it makes the copy sheet 11, and what was sheet 11 now sheet 12, etc. Any thoughts on how to avoid this?


Thanks,
Chris