Hi Kelson,
You need to install a macro, see
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
Microsoft Word does have the feature builtin, but not Excel.
To install the macro see
http://www.mvps.org/dmcritchie/excel....htm#havemacro
You would make your selection and then invoke the macro.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
"Kelson"
How can I change the range between B9 to B500 in capital letters.
I would like to do it in a "on load" event, not using "=UPPER" because I
don't want to use adjacent columns.