There is a known bug in XL97 and XL2K regarding PasteSpecial of Validation
and AllExceptBorders. Refer to the following MS Knowledge Base articles:

XL97: Problems with Arguments of PasteSpecial Method (Q171281)
http://support.microsoft.com/default...;EN-US;Q171281

XL97: Problems with Arguments of PasteSpecial Method (Q255520)
http://support.microsoft.com/default...;EN-US;Q255520

My preferred workaround is to declare the enum's as public:
Const xlPasteValidation = 6
Const xlPasteAllExceptBorders = 7

Hope this helps
James dot Becker at NCR dot com
--
~
~
~
:wq!

"Bob Phillips" wrote in message
...
Run it through the macro recorder. It shouldn't take long.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Syrus the Virus " wrote
in
message ...
Ummmmmmm yeah I knew that I'm not as stupid as I look but How can I put
that in VBA coding?????


Please help!!!!


---
Message posted from http://www.ExcelForum.com/