Take the 2-minute tour ×  I'm currently trying to write a macro
based on sheet change, where the letters in a table column are
automatically converted to upper case. So, for example, if I
entered "abcde-12345-678" into a cell, it would automatically
correct to "ABCDE-12345-678". After doing some digging, I found
some code that has worked for some people, but I'm having
trouble tweaking it to suit my needs.  Private Sub
Worksheet_Change(ByVal Target As Range)     If Intersect(Target,
Range("E:E")) Is Nothing Then Exit Sub
Application.EnableEvents = False     Target = UCase(Target)
Application.EnableEvents = True End Sub  There are two things
that I would like to address. The first being, that this code
isn't currently working for me. I have it in the correct
location according to the author (located in the Sheet1 object).
Are there any ideas as to why this isn't working?  The second is
that I would like to modify the code to refer to a table column
rather than a range. For example, I've tried changing