Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm going to be comparing a bunch of string variables in a case-insensitive scenario. I will be using the tried and true method of "If LCase(string1) = LCase(string2) Then..." However, I'm going to be doing this thousands of times. It's irrelevant to me if I compare the strings in upper case or lower. Is it any more "work" for VBA to convert a string to all uppers vs all lowers (or vice versa)? Is ~5,000 conversions enough for any difference (if there is one) to impact performance? Thanks. -- Hmm...they have the Internet on COMPUTERS now! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I get VBA script to read a word with both lcase and ucase lett | Excel Programming | |||
UCase? | Excel Programming | |||
Get…UCase or LCase ??? | Excel Programming | |||
Get…UCase or LCase ??? | Excel Programming | |||
UCase Help | Excel Programming |