I have been using the following code to force any text entered into excel to Uppercase:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = VBA.UCase(Target.Value)
This is working fine.
However, if I delete the contents of a cell I get a VBA
Run-time error '13':
This error also appears if I paste into a cell.
Any ideas how I can get around that?
Thanks in advance