Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change range in capital letters on load
Hi all
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 dont wanna use adjacent column. Any help? Cheers Kelson |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change range in capital letters on load
Do you mean when the workbook first opens? Place something like this
in the ThisWorkbook module. Private Sub Workbook_Open() Dim r As Range For Each r In Sheets("Data").Range("B9:B500") If Not r.HasFormula And Not IsNumeric(r) Then _ r.Value = UCase(r.Value) Next r End Sub Kelson wrote: Hi all 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 dont wanna use adjacent column. Any help? Cheers Kelson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change range in capital letters on load | Excel Discussion (Misc queries) | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
how to change existing column to capital letters | Excel Discussion (Misc queries) | |||
How do I change a column of cells to all capital letters? | Excel Worksheet Functions | |||
Auto change font to 'capital letters' | Excel Worksheet Functions |