UCase and LCase....
--
HTH...

Jim Thomlinson


"Bret" wrote:

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.