Capturing current Worksheet Name as a variable

[Jimbob]

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

 

[Jim Thomlinson]

Try this...

sub test()
msgbox activesheet.name
end sub

 

[Jason Lepack]

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

 

[Jimbob]

Jason and Jim
You guys are amazing - and so quick

Thank you