Sorry my mistake, you are right!

Now I have understood where the code goes (on Sheet1), however, when
enter a duplicate type onto the worksheet, there is a VB error.

It says End With without With, even if there is a With!

(I have attached a pic of the VB window with the code and error).

Do you know why this is ocurring? Is it something I have done?

Thanks!

Attachment filename: vberror.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=41610
--
Message posted from http://www.ExcelForum.com