| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting data entry to unique entries only in a specific range
I can restrict data entry to unique entries only in the range E7 to E500
using data validation: =IF(COUNTIF($E$7:$E$500,E7)=1 However unless I lock down sheet to stop copying and pasting this quickly becomes worthless. How do I accomplish the same thing in VBA? I need bullet proof validation while leaving the sheet flexible enough to allow cutting and pasting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting data entry to A-Z a-z 0-9 | Excel Discussion (Misc queries) | |||
| Find number of unique entries within a date range | Excel Worksheet Functions | |||
| Find number of unique entries within a date range | Excel Worksheet Functions | |||
| Count unique entries in data range | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Threaded Mode
