Excel Lower Case

  Monoux 11:58 12 Sep 2008

I am trying without success to get VBA code to look at a set of cells, check the words are in lower case and if not make them lower case.

The cells are in a range of a1:a50

Any ideas anyone


  Charence 12:10 12 Sep 2008

can you post your code as well?

  VoG II 12:30 12 Sep 2008

Sub lower()
Dim c As Range
For Each c In Range("A1:A50")
c.Value = LCase(c.Value)
Next c
End Sub

  Monoux 17:15 12 Sep 2008

VoG™ -- Many thanks -- works a treat -- as usual !

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

HomePod review

Les meilleurs logiciels de montage vidéo gratuits (2018)