Setting variable = to sheet name

Jeff Armstrong · Jul 26, 2004

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 · Jul 26, 2004

Try this

SheetName = ActiveSheet.Name

Michael Tomasura

Frank Kabel · Jul 26, 2004

Hi
SheetName = activesheet.name

Setting variable = to sheet name

Jeff Armstrong

Michael Tomasura

Frank Kabel