>>Hi all,
>>
>>Does anyone know what is the decimal value of the Excel Paste Special constant: xlDataValidation? The VBA Help does not list this value nor does the VBA Object Browser.
>>
>>TIA.
>
>

>#DEFINE xlPasteSpecialOperationAdd	2	
>#DEFINE xlPasteSpecialOperationDivide	5	
>#DEFINE xlPasteSpecialOperationMultiply	4	
>#DEFINE xlPasteSpecialOperationNone	-4142	
>#DEFINE xlPasteSpecialOperationSubtract	3	
>#DEFINE xlPasteAll	-4104	
>#DEFINE xlPasteAllExceptBorders	7	
>#DEFINE xlPasteFormats	-4122	
>#DEFINE xlPasteFormulas	-4123	
>#DEFINE xlPasteComments	-4144	
>#DEFINE xlPasteValues	-4163
>

>These are listed both in VBA help and in VBA object browser (and VFP object browser with Excel type lib loaded). In object browser enter xlPasteSpecialOperation and xlPAsteType as search text.
>Cetin

Thanks Cetin. I got those other constants. It is the PasteSpecial - Paste Validation option constant that I need.