Paul,

Dim S As String
S = ActiveSheet.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Paul" wrote in message
...
what is the code to have vba return the active sheet name
as a variable??

I tried:

dim xxx as string
xxx = worksheets.value

but no workie