auto correct small leters to caps letters

[Santhosh]

How to change all the small letters in a work sheet to caps letters

 

[מיכ×ל (מיקי) ×בידן]

Your function is: UPPER
You may use it in an adjacent sheet to achieve what you want OR to run a
macro on all the used-cells in your sheen to change the appropriate letters.
Micky

 

[מיכ×ל (מיקי) ×בידן]

Forgot the Macro:
----------------------------------------------------------------
Sub MakeAllLettersUppercase()
For Each CL In Selection
CL.Value = UCase(CL)
Next
End Sub

 

[Jacob Skaria]

Hi Santhosh

If you are looking for Autocorrect then try the below. Select the sheet tab
which you want to work with. Right click the sheet tab and click on 'View
Code'. This will launch VBE. Paste the below code to the right blank portion.
Get back to to workbook and try out.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.HasFormula Then Target.Value = UCase(Target.Value)
End Sub

 

[Gord Dibben]

Micky

Be careful with that macro.

If any formulas in the selected range, your code will change them to values
only.

I suggest this revision.

Sub MakeAllLettersUppercase()
For Each CL In Selection
CL.Formula = UCase(CL.Formula)
Next
End Sub


Gord Dibben MS Excel MVP