set Data validation by macro code

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • 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