Forum Discussion
Why does "myTest=Lower(myInput)" not work ?
Why does "myTest=Lower(myInput)" not work ? I have also tried "myTest=WorksheetFunction.Lower(myInput)" as well, but that does not work either.
The relevant VBA function is called LCase. Since this is a direct equivalent of the Excel function LOWER, Lower has not been implemented as a method of the WorksheetFunction object. So:
myTest = LCase(myInput)
(Its opposite is UCase)