For Each C In myRng
With C
S = CStr(C.Value)
S = UCase(WorksheetFunction.Clean _
(WorksheetFunction.Trim(S)))
C = S.Value '*
.WrapText = True
.Rows.AutoFit
End With
Next C
S is Dimmed as a String.
On the marked line (*) I'm getting an Invalid Qualifier error message.
Why please?
Regards.
Bookmarks