Macro's and Validation rules??

Hello all,

I have a workbook I am creating to help with the scheduling of my section. In this workbook I have created three macros to past data that is repeated often. The problem is that pasting the data overrides the validations, In this case pull down lists.

Can I edit the macro to past only values and would that leave the list intact?

Thanks in advance for the help.

Yes; see the PasteSpecial method.

Thanks for the reply.

I was hoping to find out how to edit the macro's with paste special?
The macro currently reads like this:
ActiveSheet.Paste

do I simply change it to:
ActiveSheet.PasteSpecial

Thank you.

Good job, Mr. 1!