Hi, is there a way to avoid dragging the entire contents other than cell value of a data validation cell (validation type, settings, message, etc.) into an adjacent cell with or without its own validation so that only the cell value gets copied over, but the target cell(s) keep their data validation contents/settings? In vba across workbook. Thanks