| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert text to all caps
Hi Patrick
For Each c in Range("B3:M2500").SpecialCells(xlCellTypeConstants ,xlTextValues) c.Value = UCase(c.Value) Next c Richard "Patrick C. Simonds" wrote in message ... Is there any way to convert all text, in the range B3:M2500, to all capital letters from within a macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert to Caps | New Users to Excel | |||
| fix all caps text to first letter caps | Excel Discussion (Misc queries) | |||
| How do convert an entire column of text in Excel to all caps? | Excel Discussion (Misc queries) | |||
| HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? | Excel Worksheet Functions | |||
| How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
![Richard Schollar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
