Copying Cell Validation

Resolved · Medium Priority · Version 2010

Sat 12 May 2012, 15:23 Delegate Raffaele said...

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

Mon 14 May 2012, 09:27 Trainer Mark said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips