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

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