Sincity_Jason
New Member
- Joined
- Sep 27, 2002
- Messages
- 11
Heres one for you guys.. should be easy enough. I have a column A, which is fomatted with a data validation = to range("name"). Need to have a vba code to check for duplicate values, then show msgbox, then goto duplicates for rentry. Here's the quirk. In Between the values that are entered there will be many blanks. So hence the countif function in the valdition allow box..doesn't work..Any ideas..
Jason
Jason