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.
Honor 9 Lite review
Les meilleurs logiciels de montage vidéo gratuits (2018)
© Copyright 2018 IDG UK. All Rights Reserved.