vba count number of string in a sheet name

[thameem127]

Dears

I am looking for your help.I need a vba code to count number of string in a sheet name.

Regards

Thameem

[Jakobshavn]

If the sheet name is composed of a number of strings (or words) then:

Please Login or Register  to view this content.

will count the number of strings.

[thameem127]

Thanks for your help.
My activesheet name is March that means 5 character string. I run your code and shows msgbox 1.

[thameem127]

Yes. I did it.I found answer

Here is the code

Please Login or Register  to view this content.