You can use the Left function to get the first 3 letters,
for example:

If Left(Sheets(Worksheets(x).Name).Name,3) = "Jul" Then

Hope this helps,
Helen


-----Original Message-----
Following problem:
There are some workbooks with 12 sheets each. these
sheets are called:
"Jan 00", "Feb 00", ...,"Dec 00" or "Jan 03, ..., "Dec
03".

I know that I can refer to the 'internal' number of the
sheets (1 to
12). But in my case I have to select the sheets by the
user-defined-name. The macro should exist over many
years, so I can
only use part of the name = monthname.

I would like to have code like that:

If Sheets(Worksheets(x).Name).Name = "July 00"
Then '(that works)

where the 00-part is variable!

Is there a possibility to refer only to a PART of the
user defined
sheet name?

TIA Walt
.