Hi all. I'm not so great at macros or vba. I generally get through by finding bits and pieces on the net and getting it to work.
I have the following code which I've used in another of my sheets.
Can some pls advise how I turn this into a stand-alone macro?
If Not (Application.Intersect(Target, Range("B3")) _
Is Nothing) Then
With Target
If Not .HasFormula Then
Application.EnableEvents = False
.Value = UCase(.Value)
Application.EnableEvents = True
End If
End Sub
I have the following code which I've used in another of my sheets.
Can some pls advise how I turn this into a stand-alone macro?
If Not (Application.Intersect(Target, Range("B3")) _
Is Nothing) Then
With Target
If Not .HasFormula Then
Application.EnableEvents = False
.Value = UCase(.Value)
Application.EnableEvents = True
End If
End Sub