Avatar of kbay808
Flag for United States of America

asked on 

How to modify my code to not be case sensitive?

The below code searches for the string “BUILDING:", but it will only find it if it’s all in caps. How do I make it not be case sensitive?

strTmp = ""
strTmp = Filter(aLines, "BUILDING:")(0)
Range("X1") = Trim(Split(strTmp, ":")(1)

Open in new window

Microsoft ExcelVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon