ActiveSheet Property [Excel 2003 VBA Language Reference]

ActiveSheet Property [Excel 2003 VBA Language Reference] ... Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window ... MsgBox "The name of the active sheet is " & ActiveSheet.

msdn.microsoft.com