Select the sheet to the right Q

S

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

Peter T

Another way

Sheets("Form").Next.Select

there's also .Previous

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

Regards,
Peter T
 
Top