| |
| | Proper, and other Text changes -- Use of Special Cells |
 | | With a macro the change is done in place, you can select entire columns or other selection, invoke the macro and you are finished. |
 | | invoking the proper_case macro took 0.070 seconds whether changes were actually made or not, involving excuting an external macro, and extra code for exceptions with some words after first word to appear in lowercase (and, the, on, a) to appear in lowercase,and other exceptions. |
 | | Note event macros are stored with the worksheet unlike normal macros which are stored in modules. |
| www.mvps.org /dmcritchie/excel/proper.htm (5311 words) |
|