Retrieve worksheet name

[student123]

I want to retrieve the name of the currently active worksheet and I thought I could use a statement like:

Name1=worksheet.name ( I have a DIM statement for Name1 as string)

But I get an error.

How can I extract name of the currently active worhseet?

Thanks

 

[Smitty]

Welcome to the Board!

Would you believe ActiveSheet.Name?

Hope that helps,

 

[student123]

Thanks Smitty