To use VBA macro to change case in Excel, copy the following formula and paste it into the Code Module. Just make sure you use the right terms (Uppercase / Lowercase) based on the different casing requiredSub Uppercase / Lowercase ()For Each Cell In SelectionIf Not Cell.HasFormula ThenCell.Value = UCase / LCase (Cell.Value)End ifNext CellEnd Sub