Dave
Thanks for the help. And Ron too. A little background on this one
computer. Their IT people found some problems with some of the contents of
the hard drive, so IT reformatted the hard drive and reinstalled everything.
Maybe a problem?
Also, 2 of the other people (remotely located in the state) brought THEIR
workbook and ran it on this one problem computer and got the same error.
The head guy is going there tomorrow and will probably reinstall Excel.
It's 2003 by the way. Thanks again. Otto
"Dave Peterson" wrote in message
...
You sure that the user isn't using xl2k?
Dest.PasteSpecial 8
(a bug for that constant that was fixed in xl2002)

If no, then I'd check the worksheet protection, lockedness of cells,
merged
cells. Something different for that paste.


Otto Moehrbach wrote:

Excel XP & 2003
I wrote some code for an OP that is being used by 4 or 5 other people,
each
with his own computer. Everything is working fine except for one person.
That person is getting an error on the statement:
Dest.PasteSpecial xlPasteValues
The error is:
"PasteSpecial method of range class failed."
By phone I got him to enter a MsgBox before that line asking for the
Dest.Address. Dest has a valid cell address.
I had the OP to check that all the references were the same on all the
computers. They are. Or so I'm told.
I am baffled because no error is created by any other computer and the
code
is identical on all computers.
Does anyone have any suggestions or ideas to solve this one? Thanks for
your time. Otto

--

Dave Peterson