Workbook.ActiveSheet property (Excel)
Returns a Worksheet object that represents the active sheet (the sheet on top) in the active workbook or specified workbook. Returns Nothing if no sheet is active.
Syntax
expression.ActiveSheet
expression A variable that represents a Workbook object.
Remarks
Using the ActiveSheet property without an object qualifier returns the active sheet in the active workbook in the active window.
If a workbook appears in more than one window, the active sheet might be different in different windows.
Example
This example displays the name of the active sheet.
MsgBox "The name of the active sheet is " & ActiveSheet.Name
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for