If I record a macro to copy validation details only from one row or cell to another using Paste/Special/Validation the macro records fine and the code looks like
eg
Rows("41:41").Select
Selection.Copy
Rows("43:43").Select
Selection.PasteSpecial Paste:=xlDataValidation, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
if I try and run the macro I get a response
"Run time error 1004
Paste Special method of rangeclass failed".....why??
any quick clever ways of copying validations??