PDA

View Full Version : Help next sheet macro



voyagerphoen
01-28-2019, 04:38 AM
Please reply a macro code for selecting next sheet in excel please.....

JimmyTheHand
01-28-2019, 05:17 AM
Sheets(Application.WorksheetFunction.Min(Activesheet.Index+1, Sheets.Count)).Select

Aflatoon
01-28-2019, 08:00 AM
I don't know why you'd bother, but:


Sub selectNextSheet()
On Error Resume Next
ActiveSheet.Next.Select
End Sub