Export (0) Print
Expand All
AutoAttach Property
AutoCorrect Property
AutoExpandListRange Property
AutoFilter Property
AutoFilterMode Property
AutoFormat Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutoLayout Property
AutoLength Property
AutoLoad Property
AutoMargins Property
AutomaticStyles Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
AutoRepublish Property
AutoScaleFont Property
AutoScaling Property
AutoShapeType Property
AutoShowCount Property
AutoShowField Property
AutoShowRange Property
AutoShowType Property
AutoSize Property
AutoSortField Property
AutoSortOrder Property
AutoText Property
AutoUpdate Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
Expand Minimize

ActiveSheet Property [Excel 2003 VBA Language Reference]

Office 2003

Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only.


If you don't specify an object qualifier, this property returns the active sheet in the active workbook.

If a workbook appears in more than one window, the ActiveSheet property may be different in different windows.


This example displays the name of the active sheet.

MsgBox "The name of the active sheet is " & ActiveSheet.Name

See Also | Activate Method | Select Method

© 2015 Microsoft