+ Reply to Thread
Results 1 to 6 of 6

Data validation no longer copies to new workbook, it used to

  1. #1
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    Data validation no longer copies to new workbook, it used to

    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?

    Please Login or Register  to view this content.
    Thanks

    Z

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Data validation no longer copies to new workbook, it used to

    Had a quick fiddle with this... certainly this copies over cell validation in my example files:
    Please Login or Register  to view this content.
    Want to give that a try?

    Tim
    Never stop learning!
    <--- please consider *-ing !

  3. #3
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    Re: Data validation no longer copies to new workbook, it used to

    Thank you for your reply Tim. Unfortunately I get the same result, the sheet copies to the new workbook with no issues, but the data validation is lost. Any other ideas?

    The code above used to work with no issues and nothing has changed since I last ran the code.

    Thanks

    Z

  4. #4
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Data validation no longer copies to new workbook, it used to

    The key here is why it stopped working - what's changed, I wonder
    • Windoze update/different version?
    • Excel version?
    • Change in workbook?
    • Change in workbook location?

    I'm afraid I'm out of suggestions.

    Tim

  5. #5
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    Re: Data validation no longer copies to new workbook, it used to

    Hi Tim,

    I got to the bottom of it, it was caused by a Microsoft Excel update version 2003 from version 2002. I rolled back the versions and my data validations started working again.

    Thanks for your help.

    Zak

  6. #6
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Data validation no longer copies to new workbook, it used to

    Aaaaand that's the kind of thing that catches us all out. Glad you got to the bottom of it - and thanks for rep!

    Tim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 08-25-2018, 09:00 PM
  2. Create multiple workbook copies from one workbook and change data within every
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2018, 11:32 AM
  3. [SOLVED] Data Validation no longer working.
    By graeme27uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2017, 03:36 PM
  4. [SOLVED] Data Validation no longer works after save
    By Maltese Falcon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-13-2014, 01:53 AM
  5. How to make drop down list (data validation) become longer by using any vba?
    By kikilala in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 03:08 PM
  6. Data Validation Use to Work is No Longer Working
    By Charlene Hainsworth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2013, 05:53 PM
  7. Replies: 0
    Last Post: 07-27-2011, 09:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1