Hello again, I need a macro to convert columns B and C to all uppercase letters as these are names and we must look professional. Thanks in advance.
Hello again, I need a macro to convert columns B and C to all uppercase letters as these are names and we must look professional. Thanks in advance.
Last edited by TWent; 10-14-2010 at 02:12 PM.
Try this and report back:
Please Login or Register to view this content.
I receive an Error when running this. Run-time error '13': Type Mismatch
Thank you for the speedy response.
Another alternative might be...
[code removed - garbage]
If the values in B:C are generated by formulae you will need to adjust the formulae directly (see UPPER function in XL Help)
Last edited by DonkeyOte; 10-14-2010 at 01:36 PM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Sorry - prior code is nonsense...
Please Login or Register to view this content.
Ahh this one works great. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks