I suspect it is because of the following line:If Target.Cells.Count > 1 Then Exit SubThat says, If you have a range selected of more than one cell, thendon't perform the operation.