Select the sheet to the right Q
 

How do I select the sheet to the right of my sheet "Form", I thought
it was something like below, but its not

Thanks


ActiveSheet.Select after:=Sheets("Form")

Select the sheet to the right Q
 

Sheets(Sheets("Form").Index + 1).Select
Daniel

How do I select the sheet to the right of my sheet "Form", I thought
it was something like below, but its not

Thanks


ActiveSheet.Select after:=Sheets("Form")

Select the sheet to the right Q
 

Another way

Sheets("Form").Next.Select

there's also .Previous

If in doubt, first do
Sheets("Form").Parent.Activate

Regards,
Peter T



"Seanie" wrote in message
...
How do I select the sheet to the right of my sheet "Form", I thought
it was something like below, but its not

Thanks


ActiveSheet.Select after:=Sheets("Form")

Select the sheet to the right Q
 

Thanks works a treat