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.
expression A variable that represents a Workbook object.
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.
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.