copy entire row with validations to multiples rows in same excel sheet

Nov 21, 2011 at 10:54 AM

Hi i am srikanth trying to do copy a row with validations for several columns to other rows but it is not happening showing error. Please help us to find a way to copy the validations from one row to multiple rows.

Nov 24, 2011 at 1:28 PM

Hello, i also have the same problem - i try to copy validations for several columns to several rows.

Currentrly i am using following code:

ExcelRangeBase destRange = ws.Cells[3, 1, table.Rows.Count, 81];
ws.Cells[2, 1, 2, 81].Copy(destRange);

But the validation is not copied!

Maybe there is a function like "copy" -> "paste formulas only" like it is available in Excel2007.

Stefan