I have a workbook with several sheets for different types of client. I need
to capture the client type from the sheet name but how to do this with VBA is
a mystery.

Any support gratefuly received.
Many Thanks

Try this...

sub test()
msgbox activesheet.name
end sub
--
HTH...

Jim Thomlinson


"Jimbob" wrote:

> I have a workbook with several sheets for different types of client. I need
> to capture the client type from the sheet name but how to do this with VBA is
> a mystery.
>
> Any support gratefuly received.
> Many Thanks

Public Sub ws_name()
Dim s As String
s = ActiveSheet.Name
MsgBox s
End Sub



On Apr 4, 3:03 pm, Jimbob <Jim...@discussions.microsoft.com> wrote:
> I have a workbook with several sheets for different types of client. I need
> to capture the client type from the sheet name but how to do this with VBA is
> a mystery.
>
> Any support gratefuly received.
> Many Thanks

Jason and Jim
You guys are amazing - and so quick

Thank you


"Jason Lepack" wrote:

> Public Sub ws_name()
> Dim s As String
> s = ActiveSheet.Name
> MsgBox s
> End Sub
>
>
>
> On Apr 4, 3:03 pm, Jimbob <Jim...@discussions.microsoft.com> wrote:
> > I have a workbook with several sheets for different types of client. I need
> > to capture the client type from the sheet name but how to do this with VBA is
> > a mystery.
> >
> > Any support gratefuly received.
> > Many Thanks
>
>