+ Reply to Thread
Results 1 to 6 of 6

Macro is not copying data validation in the cells

  1. #1
    Registered User
    Join Date
    08-31-2019
    Location
    Bangalore
    MS-Off Ver
    O365
    Posts
    27

    Macro is not copying data validation in the cells

    I have a macro to copy a selection from a sheet and email it as a separate attachment, however it is not copying the data validation that exists in those cells.

    In the attached sheet there is validation that exists in columns AT, AU, AV, AW, and AY. When I Run the code below it doesn't copy the validation into the sheet being e-mailed. I need the attachment to have the same validation in those columns as the original sheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Macro is not copying data validation in the cells

    Change this snippet...
    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    08-31-2019
    Location
    Bangalore
    MS-Off Ver
    O365
    Posts
    27

    Re: Macro is not copying data validation in the cells

    This doent work, i think the issue is that the validation is a "List" with the source of the list pointing to a range in the work book

    Example: Validation type "List"
    Source =Disp!$C$2:$C$53

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Macro is not copying data validation in the cells

    Why so many blank rows with all this validation...
    Gonna have to copy list over as well...

  5. #5
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    1,293

    Re: Macro is not copying data validation in the cells

    Instead
    Please Login or Register  to view this content.
    use
    Please Login or Register  to view this content.
    Artik

  6. #6
    Registered User
    Join Date
    08-31-2019
    Location
    Bangalore
    MS-Off Ver
    O365
    Posts
    27

    Re: Macro is not copying data validation in the cells

    Thanks, this works great !!!

+ 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. Copying data in Cells with macro which adds the data to other parts of workbook $30
    By switzd0d in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-24-2015, 08:24 AM
  2. Macro for copying and pasting cells with data
    By nadeem77 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2014, 01:26 PM
  3. Validation issue when copying cells
    By jimbo2112 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2013, 12:35 AM
  4. Need macro which locks cells (C57:C61) based on data validation selection (C1)
    By mopetten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2012, 04:17 PM
  5. Replies: 1
    Last Post: 11-22-2011, 02:36 PM
  6. Macro to split cell data into rows and copying other cells
    By stealthman in forum Excel General
    Replies: 4
    Last Post: 08-26-2010, 07:52 PM
  7. [SOLVED] create a macro for copying certain data in cells
    By Brahim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2006, 02:40 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