Excel Lower Case

  Monoux 11:58 12 Sep 08

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 08

can you post your code as well?

  VoG II 12:30 12 Sep 08

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 08

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

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Apple MacBook Pro with Touch Bar review

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…