| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the sheet to the right Q
Thanks works a treat
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select sheet, Pause till Enter pressed, return to previous sheet | Excel Programming | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Use of Sheet CodeNames to Select Sheet in Different Workbook | Excel Programming | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
| Select Sheet then Select Range | Excel Programming | |||
Linear Mode
