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
--
AP

"Graham Whitehead" <gwhitehead77@hotmail.com> a écrit dans le message de
news: OsPm0UQoGHA.1332@TK2MSFTNGP05.phx.gbl...
> 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?
>