I’m trying to convert all uppercase letters in just one column to lowercase. I am continually pasting data into this column so I do not want to do this with a formula that would have to involve a second column. I looked into data validation but it seems it is limited to correcting at the time of data entry which won’t work for me. I tried this…

Private Sub Worksheet_Change(ByVal Target As Range)


Target.Value = VBA.LCase(Target.Value)
End Sub

but the way it was written seems to apply to the complete sheet and not just one column. If this could be corrected (I don’t know the procedure) it may still be a problem as I find if more than one cell is being pasted at once it brings a run-time error. I was hoping that there was maybe a way to format the column but I can’t figure that out either. Any ideals here?