Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2004
    Location
    Albany, New York, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cycle from Sheet to sheet (Excel 2k)

    Hello All,

    I have a workbook with 10 sheets. The workbook is set to save every 5 min and update some formulas. After the save and update, I'd like the next sheet to display. I'm able to do this with a "Activesheet.Next.Select" However, when I get to the last sheet, it errors out. Is there anything I can do so when it's displaying the last sheet, it will cycle to the 1rst again and repeat the "slideshow"

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cycle from Sheet to sheet (Excel 2k)

    How about something like this:

    <code>
    If ActiveSheet.Index = Sheets.Count Then
    Sheets(1).Select
    Else
    Sheets(ActiveSheet.Index + 1).Select
    End If
    </code>
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •