Thanks to both of you that looks like what i need!

Cheers

"keepITcool" wrote in message
...

have a look at vba help for SpecialCells method
it has 2 modes to either select "AllValidation"
or "SameValidation"

and automates what you could manually do via
Goto Special



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"HCS" wrote:

hello,

i understand how to alter a validation drop down box using vb. how is
it possible to list using vb all validations drop downs that appear on
a sheet?

Cheers