ActiveSheet Property Example
This example displays the name of the active sheet.
MsgBox "The name of the active sheet is " & ActiveSheet.Name