Hi,

I would like to know if I can "call in" data validation using a macro.

I have a list in a certain worksheet, say Sheet "my list", and I want
to add data validation to Column A in another sheet "status". I tried
doing this manually, but then, when I run my parent macro for the
project, I have the "Clearcontents" option in that (so that when the
macro is run, it wont print out results for the previous run), and that
seems to remove the data validation property in Col A.

Can anyone help me with this? (I searched online, but most of the stuff
I found is either out of context, or too abstruse for me - I'm a
novice in VB programming, but am learning fast)

Thanks a lot,

Joe.