You can't have two different Worksheet_Change events, they need to be combined.