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

David

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

Celia

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


worked great thanks