I'm not able to replicate your file to solve this issue … Is the above worksheet event code placed in the same sheet where the DeleteEmployees macro is working ? What is the name of that sheet. Also, is Sheet3 a third sheet ? Please provide a small sample file to see the issue with the exact sheet names as per your file just with dummy data