Hi folks,

Excel 2002. I have these sheets:

...... Target Sheet .... Sheets("ReceiptsR") ...

In the Worksheet_Change event for Target Sheet, I attempt to move this sheet
to just before Sheet ReceiptsR. Sheet ReceiptsR is hidden.

ActiveSheet.Move Before:=Sheets("ReceiptsR")

It sometimes moves it to after sheet ReceiptsR instead of before. If I make
ReceiptsR visible, then do the move, then make it not visible, it seems to
always work properly. That's my workaround. Nothing in knowledge base I
could find.

I also tried this end run, but it failed in the same way:

ActiveSheet.Move After=Sheets(Sheets("ReceiptsR").Index-1)

Comments?

--
Earl Kiosterud
www.smokeylake.com