On 7 Jul 2004 19:00:59 -0700, firstname.lastname@example.org (Andrew) wrote:
>I have this particular piece of code in an application created on
>. . . . .
>.range("B" & finger).PasteSpecial xlPasteValues
>.range("B" & finger).PasteSpecial xlPasteFormats
>. . . . .
>I open the application in Excel2000 on one PC and I get the
>"PasteSpecial method of Range class failed"
>If I open the same application in Excel2000 on a different PC I do not
>get the error and the application works as expected.
>Can anyone tell me why this happens?
>Thanks in advance,
All that comes to mind for me is - which release of Excel 2000? Make
sure that they are both SR-1 and the same service pack. Help|About
will tell you the release and service pack. Look at the last four
digits of the version number. My Office 2000 Standard with SR-1 and
Service Pack 3 Shows 9.0.6926 (SP3). Updates are available on MS' web
hope that helps!
Custom Office Solutions
and Windows/UNIX applications
Please post on-topic responses to the newsgroup
To e-mail me, remove nospam from the address in the headers