vba code
 

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

vba code
 

You are going to kick yourself...

xxx = activesheet.name

Everything is obvious when you see the answer. Nothing is obvious until
then...

HTH

"Paul" wrote:

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

vba code
 

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