I get a "Object Required" error on the 2nd of the two assignment statements. I'm simply wanting to change elements of "NameArr" to consistent use of case. E.g., WASHINGTON to Washington or something like washington to Washington
[CODE For I = 0 To 1 'Fix any inconsistent use of case in the names
NameArr(I) = LCase(NameArr(I))
Left(NameArr(I), 1) = UCase(Left(NameArr(I), 1))
Next][/CODE]