Hi all,

i have the following part of a script.

    
    Range("D19").EntireRow.Select
    Selection.Copy
    Range("D20").EntireRow.Select
    Selection.Insert
    Range("I19").Offset(1, 0).Select
    Selection.Value = ""
       
    Range("E19").Value = ""
    Range("E19").Select
    Range("F18").Offset(1, 0).Select
    Selection.Value = ""
It creates a copy of the selected line, and paste it 1 row under.
I would like to let range E20 (after running the script) create a validation list with INDIRECT function, which refers to range C17.

Do any of you have a clue to script this?

Regards,
Crispy85