The issue appears to be occurring on the line
As you have converted to lower case the first time, you don't need to on subsequent occasionsActiveSheet.Cells(Row, Col2).Value = LCase(ActiveSheet.Cells(Row, Col2).Value)
Try this
If ActiveSheet.Cells(Row, Col2).Value <> LCase(ActiveSheet.Cells(Row, Col2).Value) Then ActiveSheet.Cells(Row, Col2).Value = LCase(ActiveSheet.Cells(Row, Col2).Value) End If
Bookmarks