Upper case

  • Thread starter Thread starter caredesign
  • Start date Start date
You could run a macro like the following to do that:

Sub UpperCase()
For Each oCell In ActiveSheet.UsedRange
oCell.Formula = UCase(oCell.Formula)
Next oCell
End Sub

NOTE: This preserves any formulae on the worksheet, whereas changing:
oCell.Formula = UCase(oCell.Formula)
to:
oCell.Value = UCase(oCell.Value)
would convert any formula to their results (in upper case)

Cheers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to make whole work sheet in to upper case 4
Print Area to include text box 10
CHANGE LOWER CASE TO UPPER CASE? 1
Upper / Lower Case 1
Excel: how to convert text to upper case upon entry? 13
Making Sheet all Upper Case 3
Changing from upper case to lower case 12
Formatting cells to only upper case 5

Back
Top