Excel Lower Case

  Monoux 11:58 12 Sep 2008
Locked

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

TIA

  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

OnePlus 5 review

Best of the Grad Shows 2017: UAL Central Saint Martins

MacBook Pro 15-inch (2017) review

Comment connecter un MacBook à une TV ?