T TBA Jan 17, 2004 #1 What is the command that tells VBA to treat uppercase and lowercase characters as the same? TIA. -gk-
What is the command that tells VBA to treat uppercase and lowercase characters as the same? TIA. -gk-
C Chip Pearson Jan 17, 2004 #2 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
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
O Otto Moehrbach Jan 17, 2004 #3 What do you mean by "treat" them the same? What do want Excel to do? HTH Otto
B Bob Phillips Jan 17, 2004 #4 Either upshift them UpCase(Range("A1").Value) or downshift them LCase(Range("A1").Value) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Either upshift them UpCase(Range("A1").Value) or downshift them LCase(Range("A1").Value) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
T Tom Ogilvy Jan 17, 2004 #5 As stated, Option Compare Text answers the question asked, but you might not need it. Also look in VBA help at the strcomp function.
As stated, Option Compare Text answers the question asked, but you might not need it. Also look in VBA help at the strcomp function.
