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.
Bookmarks