| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Change case setting from lower to upper with current complete doc
For anyone who may have read my response above, David Ritchie was kind
enough to point out to me a very dangerous and potentially disastrous result of my solution in that my code would inadvertantly (and unknowingly to the user) change formulas to values. Rowan's code above works fine and avoids the pitfalls of mine. Additionally, you can check out http://www.mvps.org/dmcritchie/excel/proper.htm#upper |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| changing lower case to upper case | Excel Discussion (Misc queries) | |||
| change typed text to upper case | Excel Discussion (Misc queries) | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
Hybrid Mode
