Sheet Name question
you didn't understand. You can use anyone of the the three tests I provided
the OR was not code, but prose.
All three methods, as presented, are case insensitive.
--
Regards,
Tom Ogilvy
"S G Booth" wrote in message
...
Many thanks to you all.
It seems I must test for each of the 3 possibilities.
However, I thought I had read somewhere that UCase could be used with a
mixture of upper and lower case characters.
Regards and thanks.
"Tom Ogilvy" wrote in message
...
if strcomp(sh.name,"sheet",vbTextCompare) = 0 then
or
if lcase(sh.name) = "sheet" then
or
if ucase(sh.name) = "SHEET" then
--
Regards,
Tom Ogilvy
"S G Booth" wrote in message
...
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.
|