Kya
Apko Pata He Excel Pe Case Change Karne Ka Koi Option Nahi Hota To
Hum Press Key Bana Sakte Hai Excel Me Jo Automatic Hi Case Change
Karega Aiye Pahle Dekh Lete He Kuch Example Chal
Sub upper()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = UCase(cell.Value)
End If
Next cell
End Sub
Sub proper()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value =
Application.WorksheetFunction.proper(cell.Value)
End If
Next cell
End Sub
Sub lower()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell
End Sub
