Consulting

Results 1 to 3 of 3

Thread: Help next sheet macro

  1. 01-28-2019, 04:38 AM #1
    voyagerphoen
    voyagerphoen is offline
    VBAX Regular
    Joined
    Dec 2018
    Posts
    8
    Location

    Help next sheet macro

    Please reply a macro code for selecting next sheet in excel please.....
    Reply With Quote Reply With Quote
  2. 01-28-2019, 05:17 AM #2
    JimmyTheHand
    JimmyTheHand is offline
    VBAX Expert JimmyTheHand's Avatar
    Joined
    Sep 2006
    Posts
    544
    Location
    Sheets(Application.WorksheetFunction.Min(Activesheet.Index+1, Sheets.Count)).Select
    -------------------------------------------------
    The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
    Reply With Quote Reply With Quote
  3. 01-28-2019, 08:00 AM #3
    Aflatoon
    Aflatoon is offline
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    I don't know why you'd bother, but:

    Sub selectNextSheet()
    On Error Resume Next
    ActiveSheet.Next.Select
End Sub
    Be as you wish to seem
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules