Need a VBA Ignore "Not in List" Validation Error

[garyj]

Hello all...

I have a data validation dropdown created through a unique filter on another sheet. This particular dropdown is to schedule drivers for a dispatch company, and so I created a filter that removes drivers who are already on trips during that time. The dropdown checks the dates for the trip and looks at only available drivers.

It works awesome, except that it presents a problem. When selecting the driver that is available, that driver is immediately removed from the list by the filters, and the data validation error display for the cell. The item is no longer in the list.

I would like to write code to mimic the user clicking the ignore error on that cell, but have not been successful in finding out how. I think I just don't have the language on these types of errors by which to search Google. Can anyone help?

I tried a bunch of things, the last being this... which didn't work...

Application.Range("E3").validation.ShowError=false

Gary

[Aussiebear]

Can you supply example of the code you are currently using that is erroring out?

[garyj]

Hello Aussiebear..

There really isn't any code... as it's all done by dynamic filters etc. Here is a snippet showing what I am doing, and what code there is.


31168

What you don't see here is the Bookings, where drivers are selected for trips using a drop down menu that is populated through data validation list referencing K4# above.
When the dispatch clicks on that dropdown to select a driver, the code takes that trip's bus leave time and return time and puts them into G1 and G2 respectively.
The list is looking for data spilled to column K, and that information as you can see comes from the other 4 columns.

But as soon as Jenny is selected on Bookings, the error shows up... like this... and the reason is because the selection causes Jenny to be listed in Col G above, which removes her from Col K, which removes her from the Dropdown list, and data validation says no.

31169
http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAArUAAACjCAYAAACUsObuAAAAAXNSR0IArs4c6QAA AARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAACfgSURBVHhe7d0PtBTVneDx38M Yd8E5 evu4oZDgg80arKGVZQnTlxN KeiMxBnMifgnw34giDPASSLnsyJE6IokYcSBdRkZNzMJEImoPxVMK7Ji/yRZE7iKrznAw4GTjKziX J/6D33ltV3VXVt6qru6u6X7/ fvRHV92qrrp161bXr6ur 7XsPfh6TgAAACpw9fJn3SGRH826yB0Cam A wgAAAA0LJJaAAAANDySWgAAADQ8kloAAAA0PJJaAAAANDySWgAAADQ8kloAAAA0PJJaAAAANLym uML4d4g6h3jbftMYdAgA0Mv74AvqKlnt 2N00Se19O290h1Bvs0d91x0CADSyR3bvc4dErjl3hDsE1F5LTnGHK3bHTx9xh/q B5/4gfQu2eKOodaGzRtnHnuXbDWPSBt/9RrJHTx4UIYOHeqOAZU555aN7pDIr 6a6A41B46hviW1pPaKz13sjvVdj//yp/mktuWbLW5pQe7vSAiyRlKbNfowkuOEjDSQ1HIM9RV8UcxFQgsAANC4SGoVEloAAIDGVrek9qSff N0dqi8SWgAAgMZXl6T2xO1L5QO7/1lOOLjTLakPEloAAID oS5J7Qd3/m9pOfEkOfH/rHBLao EFgAAoP oeVKrr9LKO2/Kn10wXk7Yu73uV2sBAADQ Gqe1OqrtANPP0dOHnmxfOA/Danr1VoAAAD0DzVNar2rtCf/90vN MmfaeNqLQAAAKpW06TWu0q7ftcf5KZF22XvgE9xtRYAAABVq1lS679K 2//70/ym33/Jm8efZ rtQAAAKhazZJa7yrtBz78cbfEMfDsC6q WnvzlK9GBgAAAPq/miS14Xtpw6q9Wrt0zUPuUFBUOQAAAPqXmiS1UVdpPWlcrQ0nsCS0AAAAzSPzpLbUVVpPGvfWeok sCS0AAEBzyTypLXWV1pPG1VqNhBYAAKD5ZJrURl2lPeVj/1HOHnGKnDzwA26Jg19CAAAAQCUyTWqjrtL 5RdHyL23XiKfO/M/uyWOtK7WAgAAoLlkltTG3Uu78p//VS655ofy7O7fuiUFXK0FAABAuTJLauPupb1k9FD55uwxcsawj7glBVytBQAAQLkySWrNVdo3/11y770jr277YVGc0rNFPvPaz TEXz5unT7gxA9ytRYAAACJZZLUnvDbX4v8lxHyp9fekqP//oey491jJ4gMPl1O L9b3SUCAAAA0VpyijtcsTtohc8bmL3bG 6/Ff/lQefOIH0rtki1uCWhs2b5x57F3CG5ZsVH04o4kcPHhQhg4d6o4BlTnnlo3ukMiv7proDjUHjqG JdNfPwAAAABqoc8mtfoCchaR5bKJ0uHRg0QWYW93giCIrEK98uTDNp0gaqXuSa1t43UAAACg8dU qx6tbUpv1hgEAAKDvySrBTe2LYkmlvQHleuiJH0jP3ZvdMdRa6/zx5rHn7ifNI9J2zH0ESuNLLkjDyAWb3CGRPYsnuEPNgWOotJaWFncoXtL54qSS1CYRt5p9 /bJpk2bpLe3V9588023FAAAAI3u5JNPlmHDhsm4cePkjDPOcEuLVZvY1iSpjVqFLn/qqafksccek7a2NrnooouktbXVnQoAAIBG19PTI886x0dXXJFVdcIZdffrkptyWx1SS2mSe1tsV7 Zd3d3bJkyRLp7OyUQYMGmTIAAAD0P2 99ZbcdNNNMm/ePDn99NNNWZqJbaZfFItLaDV9y4G QktCCwAA0L/pfG/MmDGyZUvhj2CVyhXLkVlSG66QHvfKvGF9D62 5QAAAAD9n877dP5nywv9wuNJZJLUxlXMG9aP kth3EMLAADQHHTep/M/fz7o8Q9r4fFSavo7tbYNAAAAQPOx5YXV5IipJ7XhyoQrrB 9AAAAQPMJ54NReWE5 WJNvijmfwyXefasmCbTpkXEij1qjiOy/tZpYgb7AF3fW9cfccfS57THCklvc0u3X/rrLC3cjqXatdI61nLbbNtUat1H1t/q9vO p9q2q2XbxzFtHHhtKdSpkn3mqPfrUnD9xdvohO2YSnO/hNsvLU4dI6JOjW7qVOa6C/ul/sdBEmn2DUfp46TR2qgUWxuGtzHtdjbLz/i4CNdZj1d67MflhuEcMTH1xFQdP348H8eOHTPx/vvvm3jvvfdy7777rol33nknd91117nPCnr gam5qQ887455DufWLZyaKyquE13HhesOu2N90PMP5KYuXKdazdO32s8Tbsc 364JVLINh9cttPR5pMPp 1OnPpALtLA6Rrwmr7zf1fu4Cq7f3o ezz0w1bL9KarFcavX0ReOkbLrcXhdbuHUhbk7JWdK7IQonjpK 3URpqsI1ln0dS2PeVHvs6/9N5oJcT6vzQyxW93NGfTyZV03tqAaDWjqxfLmtkiixe3S4j3TJjZLu0Bwr6q5HSvnqxTBnSJZ11 urqJIfKJwe4gIjRDG9EPspZqUquSZHeomH aHo6bN57zMYZzCf9WCV/1Dn78VjzdYy6hh17gzXNvXa/WYEbk1vxyVHjlVntkRXhd5vlRHz3oiK6bFryk7310E7/tHrNtnV0ih9bIAj1vYDujl1H0McKeFe58xfOGBbct DFTOdtdSqV1LKc9Tful1jcsdVbMOhI 3xNuY9t XbFH90U93f6RllOXPb7tdvdVYJuCzy2qf1SbR5QHnx/f9p5wzR2x7aJ8nskXVrDknb5ElSzrmkaJuVuD5e4G1X9EeKyfZjfPsUDJZJi1YnSM7VfJPbRLp2 5uuVdL968wXqXarPxhwjZt GGi9wfJWh1LKS1j24T LaOyx f5nlLlgjh0S9odDTfHUNrjM4rbDc4PHsbE95x29wmorwvrCcK7x280tW36h G91P026jIlX262AdivtGuI5eFf1tGLWNSdo5sMkhZv9580YcP1H1N8 15Qklzm 2OgckPCdr/lywVF6YOGdUM6bGf6lYh//2A31p2bv9QF9yfvvttyu6/WCq7/K9mc936dxcevdfSteX1qM civx8fzhdQ/4PiZw1 2rU/CSu/54L/SxgvmoobDusuqmBJdfetuLRGxf3DIC6wx/VPL8uuD2 Zht82 Leu66fDvGb3dwO4vHwyqtY3C5Jdoi1b5hHy9uk AyworauGi9zvjChf66FTPr9m23s1x/fUpsT1Sbx yL4Pa7y49qe8u4KijZPpFC/S1KsI7F49F93Nker2pFdQ9Juh/LOtZ9zPKj2im0jwLbWGL/6fYv2odRfUSJPUZKHF9RTD3CM5VYVpK6mzYr6m/RfSZYD3d5cfvLtG1weUn7Qfh4dransC5nOf712bYv/vXKbG gDZ31xPb/ouW44xX22zTbKKDKfl2qbxTVUa3PO/eF29CpS3AbS7azb3lhRe1r6lZe/c14aB9VdX6Lae8wnf/pPNB2C4Lt9gMdSWR2 4FaduBR08P qMSQKbNkknvJZeSVU2TIocPuuwh9RUZkyizfFZmRV5qP3Hba3umMHCVth3bILu9dxJFdsuNQm4x y30kOntSeX0/ KsehV6zvhEors24Rorc9ufKW4fuoZOQkX3v4uVfCOnwf7Q5W85qRdLY7XpI62kW2RaZ9Y4/s7BoSapN26VCLiOa242L/x dqvbNUnX1X3ozzryzdBm2T8/MMnjRZ9KoLVzKTbE9UmyffF3HHcfntk7W4Pl6gr2B0Hpoiixf56h6QfD mcawXGfwJtYfixOy/tg5ZlC/w6rw28ipM7DFS4vgqS5JlxdY9ndeo8vZXlcdzmcdv9eeyevTbKtsooNJ Xapv6OmlXxeSK2d5SV4nS9Xfrvr kvw8EJUPeuOV5IkNd0/tkHxreQ7JK7q19 yULjW8ZoHvsvm0BaL6SISRMqrtkOxwXw2P7Nohh9pG Q4gVea/bK8v01eq7LrZRW57GRIvY/B5cr7q/PqjkriPP5xtizghpbTdkZLWMUJ0W2TYN468otbiO hdg0 NSTdMOxY/x0lSgvuveJuKDTk1PM8QKSqKEtXmZe6LyLavpH2yFtfHXYfW3iqdXW3SEZnQKlXtx4jjtBymbSO U2H9FfaZkghx3jJQ vpIrvazYuqf0GlXW/qryeK7k K3qXFaPfltlG VV069L9Q0zvcI3YzblLC/J62Sp seouL9UeU5OQ2pJbVxG7WXi4UifOqmsXi2rQxF1v9nIUW1yaMcu9Q7kiOzaod4h5XuTc4/Ogh3ny2JvOVVfKiqvbvWn3qEtUnVcPEUOderOHX2PYLwstzutOhbLrG8cOaxeZhpZVJuntC/Sbp/BpxadBLNTq/VUSLftkPPlPGsOkOaxVPoYiT6 ylf9shrttbkcWZzLGkm1/bqP9o3Er5Pl1r/a/lJee9vyQh1R4qZ5 s vH1Ry8vI utoT sjKvAtSncF31eXIK2Weav2drqYn1pQNniSL3G9Or7V91hi3bbXa7lJ1rERWfSOiTY4cjllGVDtG vFuviag2r3ZfVNI ccyVg0OyZl3lKVqSfjxk8iJRr OyZkHMFyPquh/Vyaqzq/QX5iL236HDoUpHXUnTkhwjUcdXJUosK7buCfZt6mrZD6p9vdLq0W/TXmcl/bpU30i775SzvIh5A6 TldQvjf6iZXFOTqgfJbWTZHKbvtTuf2dwRNavsH8j0OF dLV2h8iUK0Mff/k6w5H1sjz2mv1gOTVw4nROIHkV1S0F1dyHt2dF0ccH1o95bNum2mu9Hsl6u5PWsSJp9Y0Qr02W 9pAbUfsJzxR7bhc3zAVrlvGoto8rX3hJaFx7WO nRv/rdoCfeWgQ9q6Oou/HWyps1VcH/cZPMlLbP37yade 9G0V6d0tXVEX6Eptf9U xWmO69vQ2LrXOoYKRxfld964CmxrLi6Z/0aZVPzfpDg9SruXFGPfpvWOqvp16X6hm265XUhsXKW580b9zpZqv6eon1fxfktqr3VcpK/ZlfnA 5jqrxLxLZLxd7l5SSXkcs1sn21dMg06ZxW2LNDpiyWSe6wjf7oqrPrkEyZ5evoqjPMmrJDFiyYJ uoQ0guRxR1tsmCtmWrhnDgPqxOHs2r1Tkdffl9w2EzVKqlbVcwN4Quc9amT2er2MhMM9S7vkL4X xx3VdV0U8UpSvG1DZMpiZ8sy3e4y6liJdPpGsZHt6h3srQtkwTSzBLN/Fk85JL7uUkS34 JTbzU/veIx2xv/DYn0RbX5kbT2hT6WFouU2T7xnN9pPdW/TE3vu0XucAlxfdxPJ7Ydh5352jqKP aryX7UCXzhcFPU69Hq1fGJQIljaciUDjl1rZre6Rbo15SoOic8RvQXidYu2KGOr4o6SkDcskrVP dPXqAg1O56T7Iuic0VxG9bj9SeVdVbZr0v1jeLp9teFpMpZXpLzSKn6F /7Ks9vkecHZzzMnwe2tLS4Q4VyXaaH/dNKaVFPSCW79C/GG9aPtjh /Lh5nD17tnzve98z8wJAFP3LAmtPzfYkCrvM2n7PCpm29tSYX4soQ8Sy6DeIQt or uvv17uu 8 k7AOGDDAPNpC8x41/7BN5j/pFeaVR00HgADzsVqbTObk048ckfVru2TI edVn9CmuiwAtVJJPlhq3prdU6srEt6AQYMGSU9PjxkGAE1fQSn8BI3z0WBH E/comE5 3eBrBni/43QyqS5LAC1ofM nf9p/rzQG/aEx5NI/fYD/6M37N1uoMMb1o rVq2Sj370o3LdddeZ QAAANB/ff/735c//OEPMmPGjPytB2ndgpDKlVovebWxTfPKLr74Yunq6pK33nrLjAMAAKB/0vnez372M5P/aV4 GJdHliOVK7X RfgrGA7/VVpveMuWLSbGjBkjF110kbS2tprnAwAAoPHpWw6effZZk9COHTtWxo0bZ67OeqGvvkZdrdW8R80/HFbXpNYb7 7ulmeeeUYOHjwoR48eNc8HAABA4xs4cKAMHTpUPv/5z5uLl/6Ett8ltf5hf6Ttgtu/bB6f 8Y/mceaOfCQTGr7huz yqNy K5L3KJJ0vaN3WY44Cv/KL9drOc5IA9deaH8nWUW7dxv/lzWffWTaijhfNsXyH d qha/G/FLN4TVZ6R0bf/jXn8xTeeMY9I22/dR6C0V155RT7xiU 4Y0Blvvit7e6QyJO31eBE0ockOYbikrD zktMvQgnseFx/7xeeMvx IfD6voXxZJWsv/ZLvfrhPbcr8ijXYfl8GEdXfLoV9SkR5fJwwfdnenMrGZ7VLq8 bpul3NV2e7Ht8lBPU/S S4dL2bxW552nuPG01seVaVfkfGXFsqyDFNZ/UAEAkBzsL0uNnp4r vOa7t9nmYOOPxtkVW71C2ptW1QeIPTDo9tWqah1 ms2Rl/erM8KufJ7ffeLZd ypvvU3LpTJ2I7pb1Tx0wcxvn3i733nWJfFJflNUQWZpLPVsJLzXSLjTVbbKQ/lF79dNpucdryaCqCWAq8RRNMEgOxkntT6D2JvOFzmRXg87VD/mLBNyzrcjTPDB3r3qpFd8o22wTJ4sC/0LQpqyu59 /Wsan4v/Mv6lJx2hr886XwtcukEndXulsdV0mzmMcm1ymknXOo J/vw6EGiEAPUkZhOFD7OIfp22I4PgmjI8P9nm04QoXDygOBwGtRpMF3 itkq6y rdXhs07IOjzPujkTxnueMuM/xR6g86XyXTpSpqmTX49vkgBp/Wl mPe/v5cYa3XqgQ/1jwjdIpBrFbU4QBJFlqFeefNimE4Q/tPCwxyv3l5UjlaQ2ycr9lYx7zDK84842Ldswm6dX7IybkfPkWzt L7//fTB 97vfye WuFdOzXzeMgrh8JWFx91w MsulRu/dZ7KatfLtu0PydJ/VLW48osyzPecrMOjB4kswt7uBEEQWYU5Cblhm04QOpxzf/G4xz s2eYpJfUrtZ6oSuhyW/g/ksvqozm1dhO2adnFAdn 3dtkl1rzeaefZsqGjb1KpbS75LZZ82T7Ad 8Bw7I0/Mvl4eedttCN5j612ubfJgJvjZLOJ O07x1/42u03ly1djTAtOzDrWhJvQgUQi3WVIIX38iCKLPhe11sdFDWgphm96fo7/u07TDayf/saDDZCm 4VJKzad6ocWmG9QTL5RlPe64n5kWrJQOp LtssmdzejZLDP//ET54Ac/KCeddJL8h/8xS77bG9yIlqc65MMf/rB85CMfMX8y9 Mf/7iJU045RYVK nyNUm2o1ZmwTUsvtss8U3cvRslfr9ZbfI3Ma3cTyNPa5YFvjxLZtVr epRv3lF63l2yVyWium1MtmrqXGhnU675ypPOZ2LYWLlKrdqYNlduGOabVotQqzVh6kV4obpFShH ujwQRHfqYtJUT2UXRa2I/CPUqlg/bdIIop 9XQ50GQ3o2ybJvrXJHKmMq1XOvXHTG5fLgL9xC7RcPybyzLjaJbX4D3ElR8vOlEB7btDRDVHLqN qab8uPdi VL/rmGda WXb/6NtyTWDWUXLNt38kN43VL35qPlOmHkMvit4VWKc86XxenCbj3Kz2msvH sprE6ayKvQgUQjdbdIJtb LYpvMdd8sejF3W/F8B1ZNDMwzcZX7hcJ8JFlO8TzFyykVB2TVRPXcudss05LUMyrSagd7JHleeJ6Pz92u9r/9WAmHbfmVzFN bC9ut 3F85Ved5LlFM9T/jZ4/cfetpW3UZb1T9bGTsRvX1Rk2X/8fdw2nWju8PcPW4T5y23T46jTqWeT3KAXNHyidHS5RTHaOruL/ljC8eMrZII7ffOSm0Xns6PveUJeeu89eU/Fi98ZrUqek/lLt YrrZMy7fzF/yqvv/66vPbaa/Lqq6 6sUzGWhqo0lArNGGbll6MlWVbt/q24VXZumymjG0tnrd17Ew1b2G V1/dKstmjpVWM71VZuppW2e644UYu8xfnnS Quzft1O1 LVyuUmeaxuFfVCc2BFpRLjN1Qlwwl/JI6PukOf/ Ef5o4rn7xglj/zVxwInzQOrJsi5C0XueN6Z54/P3yGy8FyZkD pJVmOO8 1jznL0PHYtbIzsJwEsX25LNRd1PJRZul6RkVa7WCPJM/bPvdjwXnJhc 8jV8tHxK2W/Oia810Rb7F853rr88Sv1L6Ukn6f82C8rx19d3G5Xf1T 1veGoPS6kyzHncfSf8rahm1e/ymeVnkbpVd/f79xQvdN9bzz75Q97rlgz53nu8sOz6vCt31F0yLC6Z8tcuceZ/mv7rlTWlS9/P0zyTxRoevihW060bxh7/PRiW6cUtM11RuzsEl 8qB nC63zZkgrW5FWm/6vpi89uHHZWt I8wkczDocdvGpxWFq4T26X0hvB2bWexfIUv QbXDtZfLWNv0jMPbB2aQyIfa9SmFpU/95Rp57cnCm5vWmStFnTPlH5aslAOm7IA8 RN1lrz2FpnpvflqnSm3XCuy83/dJ9vc55VejjvPMt8nAGPnmHl2/uTJ/DyRse1mcxvSR76kO6gWfj1IVs oSKsdiiPJ87bJBnPc eZRb4DnOI0jTx7wymyRZPnVtU1c0H cSKv 1tfFv1DP2/o1Oc0dP 1rK9xlryi84XFv1fuwb/v8y4iO/bL1X3ao7Z4vXzvNLTvtazJfbfeOr98rTyWeJzrUP/mwTW/2yPeHJg5bu/jDEzWclDoNeibISveKa3dnm1tWoZ598oJ nH6VjDcFXuVOk Fn6bEXpMe7BUFnOIr 19vwJA1QSah/TNim9ZXwd4Is4sDWf5Edcr4svnmcdXrWoTbShB4ksohwm7fKjTcW72vvqDPjB7aKPp d/ nhgXmGf1qdVeVFedkkXAmWk2iemBh3n7zxxhsq1sp15imh5ySqZ1Sk1Q6WSPQ8dXybVYW2yRSeK cPzie5T0vGhD8mHPtQhT3nzJFl hXUv/ZpD/3Eiy/onfF6p7TNR2/7jhe7d3n 26f05kpy3/ef4ZgtvPawenOweEwW5mNOg1WpqtjeL4SLRdeKDds6ileqTvqlevHEWfqS7VmxHmuO89zt3xWBg 0aJCeffLKc/IUvyJyn9gc6RRqhV6XDNq054ilZtkC9cl0wWSbkT6K1jcI ILIJe7sHYv8WcwKTs0Y4V51696o3Onq0NTBf6wj9DnSH7O0tlAUivBxL7H/gBlmw4wK568FZkfPYwrwshG8/qLSeUZFWOyR63niZdL0a/f5k bM5T7nz7JctugLXT5LxvueZbVf/euOJlp9228QF/ceJDOtfatnW7fNPq3H/0XXxwjadaN7QeZ7/0Rv2QgsP x/LpXphCrq6ZNXE4XKh5ecS7BX8hbzYHdyQgOeek /9xWfl0vt78/OkEeofE7ZpzRHjZPnRo3J0u3qBtU7PPtQ/7j7IDxKpRnGbh6N3y4/lOXWYXT9pnFvmHHZ6IDhvVLkTxcvxolfuv3SQeZP62R9Pll8f3S6zWv3TS4cjXO4VJy2Pj7TaQf 0fMT1YPm75Ufn13ReIenEzbTNo0Gflx5N/LUeX 9vPPUaPLpdx bLgcgrhL/cPR82TTtB/nMiy/tHLdsJRXF6v/qP yYdtOtG8EU5i/eF0reBwtcpPaiesDH1BrFu6O2eYSV0dd8vmmEoVKjxazhzhbtj4Xdd9 Vd955x8Tbb78gLyz5n2au5 Z3ypNuZp9GmLewKmzTiNpEYR8Q2YS93fPx5Gz5zHx1urxgicwd75blX1B888WV67AtJx/DZfZP31bHsoqHW2T6wIFyyf3uJy/qeQPVuD/y0/KhXhecFQfLk9Qz0fKd VJph7jpofInZw9U6zxL1ul2eWGJqPRWvcZ9RgbOfjL4vHAkWX7COlQd9B8nKq1/kohdto6I7YuKJNudZB5/eSi8xESHbTrRvOHvE/5 4g njzmPmn9YC4/HUafBarVK65z54r8NN65CL7/o/caXfeP0C0Lr7LnOF8oi5qk0PLZpRG3CoweJLMLe7k5slVlXPqxa/6uy/pnZgav1zj7xzxtXHr2comidLQu/qpK3eUudL4eqN7HeG1gvnpndWvw8Z8VF5U5xTHmi5afVDoWImp4v7/2u3KlWOfo7c2W8Hlft8oyq23rVNvLwlTJra/B54cgvJ6bcP yPqPLyg/7jRBX1LxkJl 1UuLg8IpzZ48v9w/6IKveHmiMftukEEQ4t/Kj5hyuRQlJr0TpCztaPq9bl/xiDU9Ee2We QXa2nD68eKP8kRcqrybUP6kujyg/1D/uPsgPEqlGcZs7sUVuPGmSPKRPlu/e7yRWXgz/tOj3kC90B2/36e3WB to bQ6VgvlMcuJCMcL0u3/ferYcJ iBMrLqmdUpNUOvkjwvN5Na8xPHJ41PJggjZ/7HetzA5GkXqm0TVzQf5zIsv5Jl 0uUrFPD0UN o8vp7VOJwgvtPCwxz s edLqsyktkeW3eB8Kaxw92yPbFp2jfPbtjOucn ndoJcZe5IWCWLlm3Kz/vyvdfJzXo 91cRWlpelvu 9ucyc8vL8rJbeV22Zfn1MlefAb56pUzIl1cfHts0ojbh0YNEFmFr915Z/nnnZPn4ew8UH1Otl8mX1BntFy86X/b0osd8qnKWjMjfD1hiOb3LZfmWUJl6To85L35JLivjvkJHqDxxPaMirXYIRYLnOV 4UUlDTzBpaOl50Ul2R1iuNnqRpF4V1l2zlQeD/uNElvUvsexQOOzTiiLD/uOFrosXtun9OTRbOZEs/O2XilzexpzKQ3O6KBxtnd3uPN25zjb7PCJtufxsWndnri1ivqX7jueOHz eO3Zsb25p5PJG5 556f3c nF5/62y asE3r3/FS7p7Rqk1H35N7yTq9dlHYB0JkEuE2d/e9TM89UTStEC/dMzp4zL10T06d43Kj73nJnSfBcoqe4y1XctOfCM0bG0/kpuvXgOlPFE0rXc oSKsd7JG8/fyva 52Bo5LtyxUzyT1qqTuL7/8srW8EPQfJ7Ksf7I2LkT09tW6/3jx2XmP58M2vT9H6WOI0HHs2LGi0HmgLapRZlKrctWNnbkZbW3B6TM6cxv9Ca2nWy3Tn7S2zcgn tF7s27A0Nz28vOlLcxv2FjdAteElVLZpWcVes32 NtDb1zY9t3TDXuv85cWG/AvYBrdsw/TguBPum4e2pbm9gfLaR2EfCJFJhNvc6yP2mL6hMO/epaHjcKm/jyZczobp0dNKheW5JkL9Nr6eUZFWO0RHkuc5x6cvpm8IzVN8THuRZPnl1r23t9daXgj6jxNZ1r/yZZsIbF9t 48X/23eE/mwTe/PUfoYIsLhzwFtUY0W/Y/qvDWTZHVZVal1vvOnIHru3mwes9Zz70VyurnfwqZNlu59Vm5qdUcrslnaT7hMHpTpsuHYCnNLx b2E SyBwvjjh6596LT5WZZKnufvUmqWmWVCvvgSfOItB1zH4HSDh48KEOHDnXHgMqMXOB9e0Zkz2Lvj U3B46hZJLcXpDGLQjZfFEsRpJ7J7x50g71jwnbtPRjs3zHJLRtMmPDPlHvPtzYJ/s2LJUZbWenUJcJstIsc2X HixzW5P JzCfKTT8ZfUI9Y9bt/wgkWoUtzlBEESW4bul1jqdIKIkmaccNU9qPWluRJ/Us09 ox9n3CorJvivjbZK64Q5suJnK2SOKe6RZWMGyIAxy6SnZ5m062H9m25j2sX5Wxb6i3jtMsb9nbc x7YUv3gWe6w5ftkqXr5LL3PkHDGjP/wKF0bOpsI4BY2TMssBUAACATGWVA9YtqfV4G9ZvE9zf7PMloTG6bpYRI26WVd7dCl2r5OYR7dLe PkIuu3mVFIovk2stf7ktEbOOywrrUEvtuvkyldhWuDwAAIAEapHv1T2p9fNvcBbhsU1LPYZ3yG3 6Z810IjlgjEpO75XNm/0/XeYLU6s2mbGx29xPrP9K20b3J9FW/aZTNna7f72tu1PNpRb52MbCcvRs6t WluHS8fOc 7wZstEsR8dKmZifT61lxkbpjltexuHRg0QWYW93giCIrEK98uTDNp0gdNRCn0pq 5sJK3PmTwi3SZesWtUhEycOl F65154g3trgU/b1TI/f5tCq0xwfuhXZtw2RwrFl8nVvr/cVra2Tnlk5QRpTWt5AAAAfQRJbcZa56yUn7tXX7s3dkrnDJVFdq2SjuEXFie2NdcqI8yffgMAAG hsJLU143xBbM7Kn0vO3CPQJT/awL2sAAAAaSCprYfhZ5p7WQEAAJAOktqsbLpBLtT3zm7SP7bl07NJbrimw/yawdkj/D/1labfyD5 qQsAADQRktoMdel7Z70vh3kxfKLzk1ozNsr8DP7wyvAzze8ZqPV667wh Du1AAAA/RBJbVYmrDRfDJvR1ha81UCNz jcKN36VwjcojS1znlENuovo3m4zwEAADSBlpz wdImMWzeOPPYu2SLeUTtFfbBVvOItDXN4YwU8HfrkYZzbtnoDon86q6J7lBz4BjqW7hSCwAAgIZ HUgsAAICGR1ILAACAhkdSCwAAgIZHUgsAAICGR1ILAACAhkdSCwAAgIZHUgsAAICGR1ILAACAhk dSCwAAgIZHUgsAAICGR1ILAACAhkdSCwAAgIZHUgsAAICGR1ILAACAhkdSCwAAgIZHUgsAAICGR 1ILAACAhkdSCwAAgIZHUgsAAICGR1ILAACAhkdSCwAAgIZHUgsAAICGR1ILAACAhkdSCwAAgIZH UgsAAICGR1ILAACAhteSU9zhfm/YvHHmsXfJFvOI2tP7YNHo2e5Yer48 Qp3qNk1zeGMFBw8eFCGDh3qjgGVOeeWje6QyK/umugONQeOob6FpBY15SW1X558uVtSvX9a wRJbR5JLZLjhIw0kNRyDPUV3H6AutDvpdIKAAAAklrUhU5F0woAAACSWtSHLTutNAAAQNMjqUVd 2G4jqDQAAABIalEX4Yut1QQAAABJLerCdsW10gAAACCpRV3oXDStAAAAIKlFXdiuuOpYfPeSfHz 7jjvlm7f/vSy87TaZN3dX4dAAAAJLWoC52L2mL 3Lny/vvvy9t/ pO8 dab8sYbr8sbr70udy2 yzq/DgAAAJJa1EUu5r vL7jFJLOvv/aavP7669K5rNM3tfg/AAAAklrUhe2Kqz/uvHOxvKES2vvvf8A63R8AAAAktagL272x4Xjo4e9Zy8MBAABAUou60LloWgEAAEBSi7qwXXGtNA AAAEhqURc6FU0rAAAASGpRF7YrrpUGAAAASS3qI3y5tZoAAABNj6QWNdW7ZIt5tOWmlQYAAEBLr ok vx02b5x59BIr1I7X9tqi0bPdofR8efIV7lCzI81HcgcPHpShQ4e6Y0Blzrllozsk8qu7JrpDzYF jqG8hqUVN JNaTSre4Q0kNSi Q4ISMNJLUcQ31Fyz0/7G6as B9O290h1BL k2ELamdPeq77hAAoFE9snufOyRyzbkj3CGg9prySi1qKyqp5Yp5urhigHLRZ5CWZu1LHEN9S1Ml tRodsD5IarNH30a56DNIC0kt gKSWtQU7Z8d2hblos8gLc3alziG hZ 0gsAAAANj6QWAAAADY kFgAAAA2PpBYAAAANj6QWAAAADY kFgAAAA2PpBYAAAANj6QWAAAADY kFgAAAA2PpBYAAAANj6QWAAAADU7k/wOXlPay1pNSRwAAAABJRU5ErkJggg==

I had thought a nice fix would be for VBA to select the Ignore Error in that triangle dropdown above. That was the reason for the post.

But another possible way would be to rewrite the formulas on the first sheet so that her name is either not excluded by the active dropdown (not sure how) but it would cause her name not to show up in Col G, which would allow it to stay in Col K, and thus there would be no error. OR else there may be a way to add the active dropdown name back to column K.

Thanks for any help.

Gary

[p45cal]

and the data validation error display for the cell. The item is no longer in the list. I'm not so sure that is a data validation error directly, it looks like Excel's more general error checking; you should be able to click the dropdown of that warning and choose Ignore error:
31176
You might be able to select multiple cells and do that.
Whether they'll stay ignored when you make another choice or re-open the workbok, I'm not sure, because I'm unable to reproduce your situation here (perhaps attach a bare bones workbook demonstrating the problem?)

[garyj]

Thanks, p45cal. When clicking that yellow error it says that the item is not in the list. It was in the list before it was selected, and not after it was selected. It is removed because of how my dynamic lists are created. I want only the drivers available for that date, so it goes through the spreadsheet to locate all drivers on trips during that date and lists them as unavailable, and then the filter removes those from the all drivers list and presents the remaining. So it makes sense that the list no longer has that driver available.

I could just have the user click the Ignore Error, and that suggestion works. My problem with it is that the main function of the spreadsheet is to connect available drivers to available buses during certain periods of time. Even with a dozen trips a day, the ignore error requires a click in the cell, a click for the drop down, and a click for Ignore. My original post was to find a way to do this programmatically after the selection is made...thus removing the issue from the user's view.

However, I found one solution... after considering last night that I could add the name back in.

A. I used a Worksheet_Change event to follow driver selection using:
If Target.Address = "$E$" & ActiveCell.Row Then
B. The "Then" adds the selected name to a new column shown below in "Less Selected"

Sheet Below Explained


Drivers Out: worksheet function generated list of all drivers on trips during any part of the time span in the active row
Less Selected: VBA generated (See A-B above)
Drivers Out 2: worksheet function generated list which removes Less Selected from Drivers Out and shows the remainder (in this case nothing)
Drivers Off: worksheet function generated list of all drivers booked off for holidays etc..
Not Avail: worksheet function generated list using Vstack of Drivers Out 2 and Drivers Off
All Drivers: worksheet function generated list of all drivers
Drivers Avail: worksheet function generated list of All Drivers less Not Avail.


This works. When I select a driver now, no error comes up. And now when I open the dropdown to view the list of drivers, the selected driver is still in the list.
And in case any of you wondered about this, I am using the same solution for the list of buses.

http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAz8AAADBCAYAAADhJQ63AAAAAXNSR0IArs4c6QAA AARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAABhaVRYdFNuaXBNZXRhZGF0YQA AAAAAeyJjbGlwUG9pbnRzIjpbeyJ4IjowLCJ5IjowfSx7IngiOjgzMSwieSI6MH0seyJ4Ijo4Mz EsInkiOjE5NH0seyJ4IjowLCJ5IjoxOTR9XX2YnpRvAAAiC0lEQVR4Xu3d34sbWXrw8Ue5X0LIT ELwbnrCSB220xe5GXqsZrJZZm kxtAsps36YhvCIF0Y02IzNuykL/vdF x5FwkzFy1CwHvhwY0JDaalmxnmHZyWbXyTi04PaQnWnVkTyMwQwv4ByjmnTpWq9LO63ZJKOt8Pl F1Sl1SleiTVeaqec5Ra2Xi7LQAAAAAw5/7A/g8AAAAAc43kBwAAAIATImVvz278k50DAABw2N/8i53BPPu1nNg5zJu9a/0/w1z5AQAAAOAEkh8AAAAATiD5AQAAAOAEkh8AAAAATiD5AQAAAOAEkh8AAAAATiD5gVtePZLVH/1IUj 6IZVX9r4kev6x2ka1nTceScveBWAC1GfP 47wPn91e/fA zEds/JdflFaDVlN/YOkUlWp6INC923MoN/Lk9X78verx/Ktvcc9vfvgq L498mYkp9XUrlhDxLh6cYNKT56Hq8xNxNfbK k/kgdECOv9YasfqwOjHPyZVz/2L6uj5/be6ZJ7e P1f4N9vWP1L7/eG729fTxuR37e nVc6lE3sN6vTH37YUj3r3xfi7F24 lYW/J0Us7M j 6Qm m9W0 qjrhfgnTybxvR28B/Skvo/t3Rdu3pOdIJnR0/4F7MfvpLLqP19oWq1KsXIS7/NNgjXUt5Wa/H1KNdS7pnuV39sl5oFNTtTrejRHZ3wme Xn6Eiq925LZi6 vNTB8MZ1yd9TB8Qje5dxJI3H9yR//XyvMVnJRpLohpra34/V/rX3aI2jx5L/dPr7aq7jxud2pHjxV u fltKkfewXq/at0l637gc7 dPpGpmrkjtyy l/eWHkht2f0I07n16YUnHWb/LWk /CL2fH8tOdyKGWFoH4e FF7JT c7OX7DGqVRL9yVDQnNBFuWD9qb8P39qviNS ueYVy6 J 8dqsccLskb9p7EqR/JfmNRLhdEnu6P47M9nX0w9uQne/OBOlDog8WX0rxzRbLm3iMp/WpEOc lq3JoHveJbF2y9yVI/ePbUjUH02Up3Am/xpvxXyPie/VU9uz Lj/w9nX7ywdSu m/p3CR NyOyfIVKfvrfXBT1PHE8/jJVMuoiHeX5bckY2cjBt0/RdnlZfXvtJKOV3Lwhd7B6n2tvou1xhdPx/P5Sfh77fV8Jwd7p r/d6RcVo1npbH37xe2H7PlX0i7/X/M1Ky9Y9/7p1LabAxfRzorh ZxBdlK2/swXHpJbqoE6K3GC/l0Dq4AfbV/IlL4c7m6vihS/Q/5yt4/6yZ65Se98qEcqgOrcfSFHJjv6udS1GeZdA11UFOtS5mil7gHnY1qPbrRc39LlziYx3pTtKxkwPr UX1rP1TqD0ogbUnw 6GDyXPYfe3PZmx/J7krnmzi9clXu39QHIyV4jZ3ykmJ48/3SBNOvw1smb59XHt/2/pakM8IDDN/fw/dr/H3uO5Lj3/nLXJLcVfWe nDF3vaM2p5 4jwmuoy/raPjNvq5vXI / 8pXcr3tf1TAvC5vajP7YrsfvKhbPnrvXRZluwqk8TVeJttvG0fcHRPMvr59TYNuD8pln/ c5NEx7n609L7Mth3dv8FJY7nOAb5J6VUUrh29T0vmQ/eM56474nebdPviVBiOs9lb61/lz192Sf7J7K2teTtx8aRHEQPFBcinVuXQ5UAGcE6TqRoSuIaUq/v21K3fal3lb3Vi3peTUXVIA5pVao997cq/vN406r6W flDFif kurrtYZlOtVpVgf0xWwcVIJ0E9UEF WjoJkwfRjKb7y/tflcfbKULh/i/e3pz0JRk8fmPrToMQu/Fy QeuS1rHcCz1udBnbK/m3qsjldfXdmftzuazi9lkooYu7vcF2 JPatrDu5Sdh8gMerNgvSNOINTMedVDJh2uqu TeswfjyBlS/6yTSkzf8xrA os2o0sczC2PKSsxDZWQ7vWpL9bN2/dCpRFHUr094GASlEAsy8blzgHVl7784 CsYuQ1zqGR 3vYfj3LPlcNxQ3bVqnevq4aRV6jJxJTJXb8Q I8Rh oo8vobf3VyINwnOeuf yV8wV0KZ96TKLwuR2D38mxv91X3ktUGZWL8W6 DJ40YtD9ybEit0wiN/zqj/kO0/sy8nLU/tMljudM5vySt yPL0tabce6Cf R7D3tbEe898Rzuduzbfo9oZLNBCWa4 KXvGU3/lLtx0VZNxU9k7GFPDP2cTLLWO46aZ8TQOJJ9/MfjzvW6TpupxKJb VSsVS311QNFJUqYUfZ5G9b5kVLIT Xx3r08lW5v5A2kEd5xKNT/dq Ln9ebSm rf/5Zvwy 4 pn8o/zEK4/rU b1Q7P/TuTfIi/YS0De2viBWd70M8pLqNTup7IuL T/dicPPet6JY8yL0TKPw0e96c7vYlLRP0/5Kl6P/6VOThdkr9Sb5qXe18H64mzvTqx WzJX6ea9FUxtW3T7j80 eRHvj/4bOeVO9I0l7X71FMHB PHsu9/Fz7/VFRirVyRdf39qQ6MO6bNGCqNenDHe1zX2SgjvL7fvfQ gMu2pls9rjzRs7KXZOuTL6VmjxN628z2d13VSJQ4 3vYfj3TPtf754GUr9gFdL8ElQTpfgnBmd zxl L9Rh1YL7nHZWD8qBgW4fELeZzd85Odz93kvC57e/8n1tTkmXm1LYn7nPuXrxzH6rn8694Ld/01qniMuj JElfHXX1p893mJqa/tWvx7 Ryquzvpf95 wkl36iEyl9i/Oe0AncHRVn//1gts1uyG /jjaY586J3C3p5GFBNtb 2NzjJxkXWfoW9cey5GX vQqb0jSlbuu9n 8gaXoh /4brf5ESuZD Y6s6weoBGbHfLEtSLnpldq1m5ve41R223M1K7y 5n95n /sO1KzjysP2s6Ee2Pxj xc2KJ8sNt7IiaQW5Z19Xr/8yRULmcTkJ9sfU/deCX/v/SNXK5dlh96f1W J 9tqySk8VK iuzbEesyfW3Cz9Pt9/Jkxyt585cxyU54PSO3Vz1md1Nu2nkj/QP5a/WY8fQfim8KyU/obGeEOhD bEUGl5X6Z5VUQvvE watP7GtRv sqX9glCMpXbeXzq/7DYzus7ld6/O/oPVZd325/VdPZPGjPgf3M1mWpe/b2XkUZ38P269n3ufq4PzhJ rAGO7rE7oCc6b4W3Ee8 prNaddke2r9svk0opqKIyoPX d5/653wJJCj63F0mfhffKi3QC8LrbOw7Ee7aMuPoTGrAh J5R/KSpd7/H4D/n8o9lzX/K77/lfS8f3ZO7fqIT5z2hpFUM7v7KlsKpSV8ZdEL92NuP2WVZ89/omT/x9mPjQO6O5Qz5d3LsfQi7qITl1uKQz7d/VUrFUvcFUer7L8z/UljyYuknMLpPUcaWr2Xu2/df15Wm7vX5yVXjheR1qdzmsSze75OEzYBvT/7bzoWEEon vic/3HgzcnXF73NjHtf6H/lP9d/TfFcZWT5ahmj0rOuS/G1ZPbcejCFVkyejsurW1/KvKpCm5M1nStkX898JOdEdtrdEaL86Z/lv2 773JmnzyEypFOOsBJ7h8rs8Ehc8eqoPj61uR3VCj2owiNmjkJ/8LfsABozP6zV/I4rDGsROG7dcz7PMI29fnS3u2 DwH7rMIGmsO43N7Qbz XRl7xrz8IKGdt4n3zElf/chcBbvIkd GCRIYleiYflAmib0XfFf6iY428j2h7lvVCfBR34x7rgXJg0p0Mqafi04WDjr70SYZF8pPuFTysX TGETyC0rejb6UVvsqjkpjXtyi77V9IrewNytDQSVBmNkelb4G/XvH8kbgzPJvt5Ye0veCq6uhPrchFyu2RKyyJSX90as642tvFn2g8I3sq8S0n79dXzfHrwUPaB/NNH6TJ6q 8J9mYZvr058VLIj78gvg 38qblaNG0TTX5Mh8bb9gszfLYoruCs3xdy91N74Op31sk0KjqXz/1pd9ixV2/bx7 TjGlUP7ClFNHa5UCk/4k68IY63OrXuGnLC/rV8esDgvceeS6V39h9Mavi7O9h /Us 1wva37TJ7yv/asm1nniH cxwTKhs6o6fmp7hiZqZ9qerudO0HuDz 3FfW47/buuSC2hiQ/xnlWX7BVj9V3ym996d/n6fYcprUe/sY1gv/wsrk657kDhPj6j3hP CSa/nFFNQdnbGei ZDoJ6/ndo8Q6kX0vAINF te8vpYeYCBvE67w1aa4gqszR3L3rh2eu99Vq3DZW2jaHfZh09tW/E4yW tyqJIgr RtjH2fxqV1LJ puL6lvqCGX npw5SF2asruoQs 478rb/P0n8of6b i5SZnYMuRTN9b3r66/h L1/tqeStYPsMhadaVz fYdvrXz3aTt5Q3mNPfhr3rncuY sOjeZe9QX3ydUhl1YH6XSorNoO4l5HS vSVdm2fw/KKYJJNZzNQoOZDrdm2eu2Hll9F/ g35FfHWQ Cg2Vqjvg2/UEr1F/iQe10pdk7cf2KOyv4/rtYB1hmbc6y5nnTEpnT397/ElvV8z9PWy/xt3nra9/a8/yhve1Pcu4fFNu6V19nvjHeUywTOj9bOLXaWD0jdtrPbd337TwudUu HMbnPHW9HvZW7c/RUaUmzDiPSdWfmYSwkb3FZR 3zN6P9gEMHvzZ0ECGOu9HJS82T5Q4emBv89DfXxGvSf85Ex/xwfbdtaTDK/kxH4lN16OsxTgAgUlb2u230toaq7Z/RjqX3NOjdKv7ehp/yCZYICBd6R2mD3H57szIEO16g104A3UYKWzsm3/HpS9BdPoH281AyOYZX9t xKpt9mi1xdqJugR1TIv5KVKAn4W7usSm9eHR5eSPdk/CQYO8Pila0 iZWt69LdRo6XpZcKjrDX/R17Km/Kn/a78md/26b3iZJjSt3CfnSHba5O1cP er4pnL3vzRouLUap3BpMte1telsJN3Xn1/DXaweVzI1q/rOU fCC1K8v2S MM1EFDPy6gt/XOg8FnIdXB5FB3tu1el/8aP4m Rl2SEH1 ddD1O/mGmNKF0HLZt5JdjD5yfw/br2fY52b/6VKX0OKdfd1poJ0n/nEe07uMXvdHwZn7QXGL 9zhxw56b0yNv5/53A6Mzax9bodyON6zL5zwRZl9bssFA3b/HUb6AY1 L/slb5EExhe 4tav9M3oek oON2/E942HZ/Q72DFtPgX3v z8vnzS94iyYMv/ZeyYXfIhZa ZRekUNaDDJy/L01Q ma8I9tb0eQkt/sLqRUWzv75zr1nHhfQ21r7xfCrRVN3Iv8YlIWpSSU f6bL0l7nRzt1gtFQSW/1TfnrtWgCpUvXflkWW7Zmp50/lF OWl/usnwgn3Uekz Ry7X pXKm345Kcr1R3rp5o75FfvNn4PZekqt2dDd/vXoEug8S0LhJrWy83bbz8uzGP9k5AAAAh/3Nv9gZzLNfqwQG82nvWv/P8BRGewMAAACAySP5AQAAAOAEkh8AAAAATiD5AQAAAOCESPLz7id/Z cAAAAAYL5ERnvTnj28wIG0kRinp6eysBAaQhJzi1i7g1jPFuI1W4iXG4jz/Hr3Wp xvBXK3gAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4YWaTn3oxJali3d7CPCLGAA C8HnMsXa0IY/nOL2J8NtNNfloVWU2lJEnt21ZlVVJqm7qn1QpvqXMhxgAABJJ3DGpJZTW8LavC4fD1EONko ytr4LU2m1p 1OzLFLKkFXPFWIMAJiSbFma4WOQmg63 v8myXjpRnFGShLanuaG7G2GjoX1ovON5XMhxolF8hNHeksOVeM42yjJJp/USMAQDOacpxQ7XTN9YkaJbr4 HhVuc2Zhwx7pbM5MeWSoUvFQ4qm4pcWuw6a /3GRm2TGzqjbJdEGmU7kpkU Juq8mqQ8u5foWBGAMA0MM/rpn/u48lMY4zweP0NOjA2qVx3LRzUea58lU115BSxnvOcOlWZF191vdar6Xr2BvzpcyE19ovSmS/E MzS17yo3dUpiTLtdClwlpBqvk tZLVvGSOt 1yNSn0O2sfZ5mYMktZ9e RnPgPj7mtpmGel1CZVVPKUpJMnze0E4gxAACDqeNaXmre8cSeoY9znNEN0Hy1U9bdXNpRt 0f 8rJrbI67qn19St7yu2q51HHPJGslJvec/qlW3pdO0tNuy1q0tUT6nl6GrDnei11Kapjr1pp8PelnWL0xOSsI8bTi/HKxtvt8DRRzXJbhaNdUHvG02yr LSlc0dAxaUtUmj7fzG3u5Yz92XL6llCt0cs061ZzkbWE1ErqL9l2 rNocTd1lpbvaVCr9GKPNf4vXz50s5NGDGeWIx9U4s1Jo5YzxbiNVvGFS/vGKSPIeGpc6yIHl98cY4z3jLZroPOqGOiYY/V3dtixD6W9R4zL/q1jMM44kyMkxHj7hzHnxJ25cerSyys5 ztjty62kXhM/JT0Do5snNazG1tnag5nRSHLvvpaXiaPseIMQDAcT2d4Q8l0he sC6RI0 c44xdZnkx/EQx6T4gejv0mX1T/hTnDHz3CGIZKaljZo/zvBZ7taKhByKa1Y74xDixMU5W8mN31mDLcp54X5Smbgn723DGbVXZb gD4E9dHwQXEGMAAM5l7McZ3UCu6ZN7Vdkf2jLuM4KYLmvK2j/HMOq1pLcOzX21gt8XZc7K3gYgxuOXrOQnvaiakyocfaJR31fZYnZJMvb2xLUqsqM3oXzLy27jbq td7mialzOShBgDAHA2cY4zF3UsyizJyPZt60D2dGXE9jlGDDvjdpo KeZqxajG owjxhOL8XSTn axNNRLXQpau51OWZHOVPWi6cx1rgBcBD0aRaYkjWxZ7gepd9xt9S/rbUYv6emO9C50hifG8x9jAMCYxTnO5ERXZIdHLPU6x9sb/fQcp1pS2VTHQilIUPFtGsoNiQwWZhu34ZOD9eKAkqgeMV6Lng8feHvaEvOIGE8qxlNIfupSDNX Zcv3I5fyzCWwmjeaVqdG8MiMQLEbKSgcp6rk/XXryR/tq2tM9LjbqpdTCW0whKCZdpak2fV884MYm2muYwwAmKQ4x5ncri5L6hzf9EhdTdUIHSi3K82NPc n4z6f7dJgyp13VfLXsz0D4x0GvvZqTXX2mvqpHEPPu16N9mWqqGEa FrVdNfWMwd9UW6JQm/8ycmI8mRin9KgHdt549jCcomFenJ6eysLCgr2FeUas3UGsZwvxmi3Eyw3EeX69e61/JpWw0d4AAAAAYDxIfgAAAAA4geQHAAAAgBNIfgAAAAA4oWfAg4d3PrdzAAAAADB7rt1 385FMdqbIxjNxB3E2h3EerYQr9lCvNxAnOcXo70BAAAAcBrJDwAAAAAnkPwAAAAAcALJDwAAAAA nkPwAAAAAcALJDwAAAC5cvZiSVLFub2HezGp8SX4AAACSoFWR1ZRqUEamoky1eWm3iRzmAhDfRC D5AQAAmDJzFj1TkuVaW9rtztQsH0l tSL8CuNsI77JQfIDAAAwRa3KquSrWSk327Kbs3da6a1DaR9uSf fa8QsIL7JQvIDAAAwNS052GuIFLZlK2YL2FxFCJdOddUs X0xguVWK1Ix870lVmaZ81x56FPCNah0Sjf g W61uVv67BlZhvxTVp8SX4AAACmpXUgum2cXcrYO4bTjcmdpWandKpZlmw139swVfflpeYtc7glW 7fUclKV/fByqoG7U9Xt8jNeeagXe0u4agW1ypSsVrqatWo7MsfbdrmaFBol2TzPMrOK CYuviQ/AAAAU7a82GmeRs6Sd50pz 225TB8CSG9JhtZ1b6MtHq1gtTCNVZ9lmsd7ElDLbfeVYo1XEsqpkVdi5Zw5XZFtY lUbobvfqglmsHC ZkXS zdxA98x9nmRlHfJMTX5IfAACAKTs66TQFTT8Qe8ZdNzijVON0NdRwTmWk1LB/Ciusq2ZmWFrWvNaxbbz65Vjdy43SlGPzsN5H5XSrVo4k9FJgEd/kIPkBAACYlvSiLKv/GsdN7/ZQumGsGsNSlqZtPLfbTSmrNm8c6a1tKUhVdnTJkS3H6tfIHap1opq/wyxL6CIHiG/ikPwAAABMTU5u6dZtdUdGdoPwG7Rn7cMR6JQc1XVJVLYst87YNvYb871lWCL1/aru3CLxere4gvgmDckPAADAFKW37ks525BSpntErZachE/D92mY1osDyqIGMKVLjZLk1YOyG2ujG9nNY1FLSqe/vt Y7 qEXy9K/jyd6x1AfJOF5AcAAGCq0rJ12A5G1Ir099AlUMHvwORk147 5S jR/zq7TcyRO6WLaPKysbaoGZsXYr NqgWb7Z8PzJMs mz0r2t aO v2MDjfgmSWpl4 22nTeePZzxXkzo6/T0VBYWFuwtzDNi7Q5iPVuI12yZ33iF pXw45pzGGfi63v3Wv9Xz5UfAAAAV7x2vxIkGvEdieQHAADAEfW7pXP89gtmBfEdjeQHAADAEfpH NNvtXaFtPJ I72gkPwAAAACc0DPgwcM7n9s5AAAAAJg9126/b eiGO3NEYwy5A5i7Q5iPVuI12whXm4gzvOL0d4AAAAAOI3kBwAAAIATSH4AAAAAOIHkBwAAAIATS H4AAAAAOIHkBwAAABPSkspqSlKrFTU3XL2olivW7S3MhuTHl QHAABgEloVWU2lZHba87Yhq7bZm1alwi iDEZ8ZwLJDwAAALrohnFGSlKWZrstbT01N2Rvc/QZ/eHSsnWonutwS81Z9SKJ1cS5G1 SHwAAAHRpynFDJLux1mnEprfkMNyoxQxzN74kPwAAANNkzoyHyo 6 kv4fSNaldVzL2P nipKd0WWuX9I/4zGcdPO9Rq6zvBr6ret9j4zn6 quYaUMt7yq12XCIa97plAfNVccuJL8gMAADAlpuGXF6n5pUftppSlJJnuRmA1L5njbbtMTQqNkm x21xENWSZ3qyxZqcp uHXcqsiOapcWtvud7c/JrXLWPOfQkqU 68zoRuz et/t6JbbVcvUCmouK WmXr4th1uhrYnzuhOM KplEhZfkh8AAICpqMvdUkMKtV3VFPWlZWtbNRYbe3IQbgMWatLe9ZfKybpZ5CDagB62THpNNnRb N9Q6bh3siVq7rHdWHpHeOpR2Uzeq/bP2fRrJ2bI0u9bZ776ebY0rzutOLOI70hTiS/IDAAAwDa0TOVL/VfO64RmaTJnQRUvLmtc6tqVRLTnYa6jG57pqcg6h 4Hos/JBI7m3tAoDEN9EIvkBAACYokLNKweKTocSrg66COmtbSlIVXb06f3WgXht46FN4w7dSDblS12lV RiJ CYLyQ8AAMA0pBdlWf13dDLOIp wTllRXZdEZctyK2bb2MgsSdbOIgbim0gkPwAAAJPQPJaGal4uZext1VjVnc4bpc1oXws9ktaYRr 3KmdZxSfIltSXhYY679WxDSyqbpaF9SM7NNLobMmTgsdlAfPtLWHxJfgAAAMamLsVQX49s X6k3El3Om WJRgG2Ew7S9Ic1t5G6JHuRLj761sTZkDbldaW7seSN7mcn/Qcxw5/0Lkt4SPQaA3zemOFNlV8R3pITFN7Wy8XbbzhvPHo4jD8W0nZ6eysLCgr2FeUas3UGsZwvxmi3zG 6/QL/vzg6VzGGfi63v3Wv9Xz5UfAAAAV/gd4fv 9gtmHvEdieQHAADAEfW7Y rXgUQgvqOR/AAAADjC/OL OPp1IBGI72gkPwAAAACc0DPgwcM7n9s5AAAAAJg9126/b eiGO3NEYwy5A5i7Q5iPVuI12whXm4gzvOL0d4AAAAAOI3kBwAAAIATSH4AAAAAOIHkBwAAAIATS H4AAAAAOIHkBwAAYA7UiylJFev2FuYN8b0YJD8AAABJ0arIaiolSWrjtiqrklLb1D2tVvh5lDMj vlNH8gMAAIARClJrt6XtT82ySCkjqdWKkALNA3fiS/IDAACAs0lvyaFqIGcbJdnkCtD8meP4kvwAAAAknS2XCpclDSqdipQxdZ259/uNDFsmNtVA3i6INEp3JbIpcbe1Xows4/RVJOI7MSQ/AAAASaYbkZmSLNdCZUm1glTzffplVPOSOd62y9Wk0O/MfZxlYsosZdW/R3LiPzzmtprGeV5CpVZNKUtJMi4mQMR3okh AAAAEqsllZ2qSKEmuzl7l5bbFdXm7D0rr5ZrBwvmZF0vs3cQbXDGWSam9OKyndPibmtd7pYaarF dtXZfWrbMZYY9OZh263iiiO kkfwAAAAkVlOOG6q9uR5ubXpyulUbPis/Ba2TIzunxdzW1oma0xcoQiVResqrhrVziO kkfwAAAAklW1IDrYsi2k7OwVN3Rr2t GM21oIl04F06FsTfH1TBzxnTiSHwAAgKRKL6ompUh1v7dHeX2/KpJdkoy9PXGtiugqqGz5llfeFHdb7XJH07ykkRTEd JIfgAAAJKieSwNycpS0OLNya1yVtcQRUfUqhdFVxEVtrdkKifS9YhfmZI0smW5H5zKj7ut3nKN0 qZE uHrzvTzPuAB8Z16fEl AAAApqouxVC/iGz5fqQ0KL11GIyo1ek/cSTlZjva8XysqpL3160nf8Svw2jjPO626uW839EMLbezJM2u55sPxNdMCYlvamXj7badN549nOt 821mnp6eysLBgb2GeEWt3EOvZQrxmC/FyA3GeX 9e659mceUHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4oWfAg4d3PrdzAAAAADB7rt1 385FMdqbIxjNxB3E2h3EerYQr9lCvNxAnOcXo70BAAAAcBrJDwAAAAAnkPwAAAAAcALJDwAAAAA nkPwAAAAAcALJDwAAAAAnkPwAAAAAcALJDwAAAAAnkPwAAAAAcALJDwAAAAAnkPwAAAAAcALJDw AAAAAnkPwAAAAAcALJDwAAAAAnkPwAAAAAcALJDwAAAAAnkPwAAAAAcALJDwAAAAAnkPwAAAAAc ALJDwAAAAAnkPwAAAAAcALJDwAAAAAnpFY23m7beePhnc/tHAAAAADMnmu337dzUT3Jz7OHLTuHeXJ6eioLCwv2FuYZsXYHsZ4txGu2EC83EOf59e61tJ2Lou wNAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAA AA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNI fgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4geQHAAAAgBNIfgAAAAA4IbWy8Xb bzhsP73xu5wAAAABg9ly7/b6di pJfp49bNk5zJPT01NZWFiwtzDPiLU7iPVsIV6zhXi5gTjPr3evpe1cFGVvAAAAAJxA8gMAAADAC SQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADACSQ/AAAAAJxA8gMAAADAASL/C9PAHVncOYXcAAAAAElFTkSuQmCC
31178

Thanks all for your ideas, and all you do to make this site worthwhile.
Gary

[p45cal]

Have an explore of
Application.ErrorCheckingOptions.ListDataValidation = FalseIt applies to the entire Excel Application, so if you want to preserve it's TRUE status for elsewhere you could put that line in the Worksheet_Activate() event and set it back to TRUE in the sheet's Worksheet_Deactivate() event. (I still can't test if this will work since I can't get such an error to appear here.)

[p45cal]

Attached is my vba-free data validation where I don't get such errors.

[garyj]

Strange, couldn't get your suggested VBA function to make a difference; though I tried to recreate the issue rather than mess up my fix on the particular issue. I caused an error, but it was always a popup box rather than a cell triangle warning, and the popup wouldn't allow me to put in the wrong data.

Your code in vbaExpress71200.xlsx is the same as mine, other than mine uses dynamic lists so that the data keeps spilling. I don't know if that makes a difference.
In my columns when I type a name into one list, the name comes off the other immediately, much the same as your data dropdowns work. My dropdowns are on another sheet of course, and the filter brings the data to this hidden sheet. The rows are not necessarily contiguous on the other sheet. I noticed that while there are workarounds for filtering a range of columns that are not contiguous, dynamic filtering prefers the ease of contiguous columns. I wonder if breaking contiguity in rows can cause the inner workings to perform differently.

I have lots of wondering... but no time to figure each one out. For now, I press forward. This certainly has been an interesting thread. Thanks

Gary