dynamic validation

[Guest]

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?

 

[merjet]

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

 

[Guest]

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

 

[JE McGimpsey]

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?