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

A

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
 
Top