Hi,
I have a script that copies worksheets from different workbooks and then pastes them into a specific workbook master. My problem is, this used to copy across the data validation rules too and all of a sudden it has stopped working. The data validation lists are in the same worksheet so that shouldn't be an issue I don't think.
I have tried to manually copy cells with data validation and pasting using the paste validation special option and this doesn't work either.
This is my code below, is it possible to tweak this to copy the data validation rules into the new worksheet?
Thanks
Z
Bookmarks