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:a50Any ideas anyoneTIA
can you post your code as well?
Sub lower()Dim c As RangeFor Each c In Range("A1:A50") c.Value = LCase(c.Value)Next cEnd Sub
VoG™ -- Many thanks -- works a treat -- as usual !
This thread is now locked and can not be replied to.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.