Ignoring case or worksheet name

[willyboy58]

How can I ignore the case of the worksheet name in the code below? If the worksheet name was entered as "clntRATE" or "ClNtRaTe" (or any other variation of upper and/or lower case), the code below doesn't recognize the variations. It only recognizes "CLNTrate"

For Each sh In .Worksheets
If sh.Name = "CLNTrate" Then

I've looked at MatchExactly, but not sure if that is what I need.

TIA

Bill

 

[SkipVought]

Hi,

Convert the strings in your compare statement to either Upper of Lower case.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com