I have a set of cells which are validated against a list so that when someone
types content into the cell, what is typed must be consistent with the
validation list. This does not require VB code and works fine when values
are typed into the cells, but not when they are pasted.

I use the worksheet's Worksheet_SelectionChange(ByVal Target As Range)
subprocedure and an If Then statement to detect when a particular set of
cells changed, and set validation ranges according to the contents of
reference cells.

But I don't have any idea how to validate values pasted into a cell or cell
range against a list. I would appreciate any help I can get.