At the top of the module, use

Option Compare Text

This will cause all text comparisons to be case insensitive.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TBA" wrote in message
...
What is the command that tells VBA to treat uppercase and
lowercase
characters as the same?

TIA.

-gk-