Call the right hand sheet

[aitor]

How can I call the right hand side sheet in vba when i have several sheets in a workbook?

Something like Sheet(next).

How can I know the name of the activate Sheet with vba language?

Thanks in advanced!

 

[VoG]

For the rightmost sheet try

Sheets(Sheets.Count)

 

[prajul89]

How can I know the name of the activate Sheet with vba language?

Thanks in advanced!

sheetname = ActiveSheet.Name

 

[prajul89]

Sub Right_Sheet()
 
If ActiveSheet.Index = Sheets.Count Then Exit Sub ' to test if the active sheet is the righmost sheet
 
sheetname = Sheets(ActiveSheet.Index + 1).Name ' Name of sheet which is in right hand side of active sheet

Sheets(ActiveSheet.Index + 1).Activate ' to activate the sheet which is in right hand side of active sheet

End Sub

This should surely help you!!!

 

[al_b_cnu]

Maybe more simply:

On Error Resume Next
Sheets(ActiveSheet.Index + 1).Activate

 

[VoG]

Or even

ActiveSheet.Next.Select

 

[prajul89]

Maybe more simply:

On Error Resume Next
Sheets(ActiveSheet.Index + 1).Activate

I don't know why, but I always avoid using Error handlers

 

[al_b_cnu]

I don't know why, but I always avoid using Error handlers

A good rule, but rules are meant to be broken

 

[prajul89]

A good rule, but rules are meant to be broken

yeap your are right