"PasteSpecial method of Range class failed" occurs in one instance of Excel but not another

Hi All,

I have this particular piece of code in an application created on
Excel2000:

. . . . .
.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,
Andrew

Mike
Thu Jul 08 06:17:38 CDT 2004

On 7 Jul 2004 19:00:59 -0700, nocalves@hotmail.com (Andrew) wrote:

>Hi All,
>
>I have this particular piece of code in an application created on
>Excel2000:
>
>. . . . .
>.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,
>Andrew


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
site.

hope that helps!


Mike Argy
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