if application.Countif(columns(7),Target)0 then
' its in the list


--
Regards,
Tom Ogilvy




"steve" wrote:

I want to validate all of the cells in Column G with a list of unique items
already in Column G. This can be triggered with the Sheet_Change event.

What is the best way to do this?