MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Non Case Sensitive

Posted by David on September 18, 2000 10:57 PM

If Left(Worksheets("Main").Cells(2, 2), mylen) = Left(Worksheets("List").Cells(x, 1), mylen) Then

How do I make this statement no case sensitive. Their are going to be numbers and letters in the strings

Posted by Celia on September 19, 0100 1:38 AM


If UCase(Left(Worksheets("Main").Cells(2, 2), mylen)) = UCase(Left(Worksheets("List").Cells(x, 1), mylen)) Then


Posted by David on September 19, 0100 2:23 AM

worked great thanks