You should be able to accomplish this with the "Ucase" command.

if ucase(Activesheet.name)="SHEET" THEN msgbox ("matches")

"S G Booth" wrote:

I need to check for a worksheet's name, and need to be sure that all the
following example names will be valid:
SHEET ....... Sheet......... or sheet

guess that's a load of "sheet"!

Can I do this reliably with UCase, or ?

If (UCase(.Name) =

Regards.