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.
1 Reply
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)
