Converts Uppercase to lowercase text in cell selection. Macro to Change All Text in a Range to Lowercase Letters

PHOTO EMBED

Wed Sep 08 2021 04:53:48 GMT+0000 (UTC)

Saved by @Darkleech #vba

Sub ConvertToLowercaseText() 'Converts Uppercase to lowercase text in cell selection. Macro to Change All Text in a Range to Lowercase Letters
    Dim Rng As Range
    For Each Rng In Selection.Cells 'sets range as selection
        If Rng.HasFormula = False Then
             'Use this line for UpperCase text; change UCase to LCase for LowerCase text.
            Rng.Value = LCase(Rng.Value)
        End If
    Next Rng
End Sub
content_copyCOPY