Get the worksheet name using VBA

[Graham Whitehead]

hi, I was just wondering of it was possible to work out and store the name
of a worksheet and if so how is it done?

 

[Ardus Petus]

Dim WsName as String
WsName = ActiveSheet.Name

HTH