There's no reason VBA cannot insert values into a cells, data validation or not. If you post your workbook, or a small version of it, with instructions on how I can replicate the problem you're...