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