Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UPPER / LOWER function VBA
In a standard spreadsheet, user has option to use Excel's built-in function:
"Upper" and "Lower" to change the case of the text. However in VBA code, using the "application.worksheetfunction" syntax, there is no selection for UPPER and LOWER, why is this? Is there another way to use this function in VBA? I need to convert all string variables in my code to UPPER case but have hit a wall with this. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert lower to upper case automatically without using UPPER | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
Function for upper and lower control limits? | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) |