Thanks Tom and Chip,

It appeared that application events was part of the problem. The code
appears to work now. However, is it possible to use the column
"NameValues", which is now set with code, as a source for a data
validation list--basically create a named range "NameValues" and then
set the range as the source for drop-down lists in another sheet.

I just tried, and Excel stalled out, but 30 sec, showed the drop-down
arrow and no data in the list. When selected, the first row (name)
appeared and could be entered into the cell, but no other names could
be seen or selected. This is my very last issue to resolve for
hopefully a long while. Thanks,

Eric