Raffaele has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Copying Cell Validation
Hi
I am able to copy and paste cell validation with the PasteSpecial method
e.g.
Range1.Copy
Range2.Cells(x,y).PasteSpecial Paste:=xlPasteValidation
Is there any alternative to using the clipboard?
Thanks
RE: Copying Cell Validation
Hello Raffaele,
The method you are using is probably the most direct route to copy validation. However, if you write the validation in VBA and not use the Data Validation from Excel, you could refer to the validation routine or make it a function procedure.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer