copy/paste dynamic validation cells

[hgchas]

hello everyone! i have been trying to create a dynamic copy/paste range but get an "object required" error. i am trying to create a drop down list for every row of data on column A. Column A changes from time to time so sometimes I have more or less records but the drop down list is consistent of items in it. it seems i am missing the dynamic copy/paste range.

this is my sample data
ID Fruit
869876
665447
768756
987653
997653
32534

this is my code:

Please Login or Register  to view this content.

[GWteB]

Remove the .Select part on the last row of your code, then it should work.