I'm pretty sure it worked few weeks ago.
I'm trying to copy a column with styles, values etc. to a newly inserted column. For performance reasons I use fixed-size ranges instead of whole columns. Some cells have named data validations such as dropdown list that point to a range of values from another
sheet. (Data validation for such cell is defined as List with value e.g. "=DDL_STATION").
Everything is pasted well but cell (column) width and these data validations.
How to copy data validations from one range to another or from one column to another?
wsRel.Cell(1, newRelationColIndex).Value = templateRange;