Ramil,

I found "xlPasteValidation" with a value of 6 in XL2002.
It is not available in XL97.

Regards,
Jim Cone
San Francisco, CA

"Ramil" wrote in message
...
Hi all,
The VBA Object browser does not list the value of the xlPasteType member:
xlDataValidation. Does anyone know the decimal value of the constant? Creating
a macro with this code does not show the value as well:
Sub Test
ActiveSheet.Cells(1,1).Value = xlDataValidation
End Sub