Tag Archive: Change case on the selected cells

Mar
19
2013

Uppercase/Lowercase conversion in Excel through VBA

Well, there is no easy way to ‘change case’ in excel. So i wrote few small VBA snippets to perform case conversion. To perform uppercase conversion on the selected cells Sub UpperCase() Dim Cell As Object For Each Cell In SelectionCell.Value = StrConv(Cell.Value, vbUpperCase) Next End Sub To perform lowercase conversion on the selected cells …

Continue reading »