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?

I want to validate all of the cells in Column G with a
list of unique items already in Column G.

I believe you need to describe your problem much more clearly. An
example will probably help.

Merjet

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?

Not sure what you're asking for - is there a specific range in column G
containing the list of unique items? Or are you trying to make sure all
the entries in column G are unique? Or something else?

In article ,
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?