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


"Santhosh" wrote:

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

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

--
Jacob


"Santhosh" wrote:

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