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

[Andrew]

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 A]

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