Setting variable = to sheet name

[Jeff Armstrong]

I have a simple question. What is the code to set a
variable to the name of the activesheet in Excel?\

Dim SheetName As String

SheetName = <code?>

Jeff

 

[Michael Tomasura]

Try this

SheetName = ActiveSheet.Name

Michael Tomasura

 

[Frank Kabel]

Hi
SheetName = activesheet.name