Setting variable = to sheet name
 

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

Setting variable = to sheet name
 

Try this

SheetName = ActiveSheet.Name

Michael Tomasura
"Jeff Armstrong" wrote in message
...
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

Setting variable = to sheet name
 

Hi
SheetName = activesheet.name

--
Regards
Frank Kabel
Frankfurt, Germany


Jeff Armstrong wrote:
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