Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As I said, the above code stops the indexing at the last sheet. If, after
you reach the last sheet, you wanted to wrap back around to the first sheet, give this a try... Worksheets(ActiveSheet.Index + 1 + Worksheets.Count * _ (ActiveSheet.Index + 1 Worksheets.Count)).Activate And if you need code to move to the Previous sheet where, if the ActiveSheet is the first one, it wraps back around to the last sheet, this code will do that... Worksheets(ActiveSheet.Index - 1 - Worksheets.Count * _ (ActiveSheet.Index = 1)).Activate Rick |