Thank you for the help here. When I first tried this I didn’t think it was working but after messing with it for a while I found out it’s just not working as I expected. In case I am using this wrong I will tell you how I inserted this code. I pressed Alt +F11 and double-click the worksheet that I want this to apply to. I changed the Target.Column = 5 to Target.Column = 3 to fit my application. Any capital letters that are added to any cell in column 3 are changed to lowercase when exiting that cell. As I was hoping for I can also paste several rows at one time and everything gets updated to lowercase. One of the drawbacks is I am adding about 12 columns and however many rows starting with A1. In this case the application does not work. I was thinking I would just clear the contents or delete the data in column 3 and copy and paste just that column (containing caps) but I get a Run-time error when I try to delete or clear the content of any the cells in this column. Now the code stops working completely until I exit and restart the program. I found that it works to just paste the column three contents (With caps) right over the column 3 (on sheet with code) and that seems to work if I don’t allow the error to occur first. Is there an easy fix to first allow me to paste data with all 12 columns and then column 3 get updated and also a fix so that if a cell is cleared or deleted in this column I don’t get the error message and have to restart the program? Thank you.