>>Thanks Cetin. I got those other constants. It is the PasteSpecial - Paste Validation option constant that I need.
>
>Sorry I don't know such an option (still using Excel2000)
>cetin

I searched the MSDN newsgroups for Excel and there was a similar post. The suggestion was to use the value: 6. I tried it and it worked.