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