set Data validation by macro code

    set Data validation by macro code

    Hi all,

    does anyone know of a way to assign Data validation rules to a range by macro code?

    I tried to just transfer the format of a range to another, but obviuosly data validation is not part of a range´s format.

    Any hint is welcome

    regards
    OMartin