vba code

[Paul]

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

 

[Guest]

You are going to kick yourself...

xxx = activesheet.name

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

HTH

 

[Chip Pearson]

Paul,

Dim S As String
S = ActiveSheet.Name


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