= Excel VBA Selecting Sheets =

In Excel terms, a ''sheet'' is any of worksheets, charts, modules, and dialog sheets.

<<TableOfContents>>

----



== Unqualified Names ==

When a new workbook is initialized, the following will be accessible objects:
 
 * `ThisWorkbook`
 * `Sheet1`
 * `Sheet2`
 * `Sheet3`

Thus the following is valid:

{{{
Sheet1.Range("A1").Value = "foo"
}}}

These names do not correspond to any component of the Excel UI. If sheets are renamed or reordered, the sheet formerly known as "Sheet1" remains accessible as `Sheet1`. If sheets are deleted, then the objects become inaccessible.

----



== Worksheets and Sheets ==

to activate the first worksheet in the active workbook, try:

{{{
Worksheets(1).Activate
}}}

To activate the first sheet (of any type) in the active workbook, try:

{{{
Sheets(1).Activate
}}}

To activate the sheet named "Sheet1" in the active workbook, try:

{{{
Sheets("Sheet1").Activate
}}}

To select multiple sheets (as for reordering sheets), try:

{{{
Sheets(Array("Sheet4", "Sheet5")).Move before:=Sheets(1)
}}}



----
CategoryRicottone