What is the syntax to change text case?

UCase(<value to be converted to upper case>)
LCase(<value to be converted to lower case>)
‘examples
MsgBox( LCase(“HELLO”)) ‘returns hello
Range (“A1”) = UCase(Range(“A1”))
Advertisements