Application.ActiveSheet Property (Excel) - MSDN - Microsoft

Returns an object that represents the active sheet (the sheet on top) in the active ... Excel 2013 ... MsgBox "The name of the active sheet is " & ActiveSheet. ... the active sheet that has the page number at the top of column B on each page. VBA.

msdn.microsoft.com