Select the sheet to the right Q

[Seanie]

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")

 

[Daniel.C]

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

 

[Peter T]

Another way

Sheets("Form").Next.Select

there's also .Previous

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

Regards,
Peter T

 

[Seanie]

Thanks works a treat