A message box popups when you duplicate in a column Thanks Lloyd
M Max Nov 24, 2006 #2 Try Debra's page at: http://www.contextures.com/xlDataVal07.html Prevent Duplicates