Copy validation list and paste it as values

If the list was manually entered:

Select the cell with the data validation list, and this macro will put out the list starting one row below that cell - if you want it elsewhere, change rngC.Offset(1) to something like Range("Z1")

Please Login or Register  to view this content.

If the list is a range reference, then use this:

Please Login or Register  to view this content.