UPPER / LOWER function VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
and for proper you would use application.proper

but rather than reinventing the wheel you can probably simply make use
of the macros in
http://www.mvps.org/dmcritchie/excel/proper.htm
which work from a selection and that selection is further restricted by
Special Cells and no matter what is used in Special Cells as arguments,
SpecialCells will also restrict to the used range. So you won't have
to worry about selecting an entire column and taking 3 minutes per
column to process an almost empty sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lower case "a" in "application" 5
Good code, need one more step 3
How to test text case for Upper/Lower/Proper 2
Changing case in a cell 1
Determine whether a character is Upper or Lower case 2
scrolling 2 frames simultaneously 2
Performance Difference - LCase vs UCase? 12
Convert list to UPPER, lower & Proper cases. 21

Back
Top