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" <[email protected]> a écrit dans le message de
news: [email protected]...
> 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?
>