@IqbalHussain-cc3iz
In this video we are going to learn how to change small letter to capital letter or we can say lower case to upper case and proper case. we will learn this method with formula and without formula, So watch the video completely and don,t skip otherwise you might miss some commands. and please like the video and subscribe my channel.
For VBA please copy this bellow codes :-
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
26 янв 2024