Code causes crash

[Newbienew]

So i am having an issue with a code that I was using. It makes everything capitalize on the page no matter where. Bu when I use code now it freezes the workbook and then crashes it. Is there anything I can do about this? I have provided the code that i use below



Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim R As Range
For Each R In Target
If Not IsEmpty(R) And Not R.HasFormula Then R.Value = UCase(R.Value)
Next R
End Sub

 

[My Aswer Is This]

So you are not installing the code the way I explained.
You keep wanting to put the code in a Module.

Well if it all works for you I guess that is great.

Normally a Macro like this is activated any time you change a value in a cell not when you press the Run Button.

 

[Newbienew]

I was actually stating that I did follow your directions the second time around, and it worked out. The first time I used it I click the run button

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

I was actually stating that I did follow your directions the second time around, and it worked out. The first time I used it I click the run button