Hi Bill,

You wait over an hour for a bus and then two turn up!

---
Regards,
Norman



"William Benson" wrote in message
...
Norman - look at the timing on our posts ... LOL

"Norman Jones" wrote in message
...
Hi Robert,

Is the macro run from a commandbutton?

If so, try setting the TakeFocusOnClick property of the button to False.


---
Regards,
Norman



"Linking to specific cells in pivot table"
crosoft.com wrote in
message ...
Hi,

I searched through previous posts but could not find anything that
directly
applies to my case -- I have a client that gets the following error when
they
run a macro on a spreadsheet I created on their laptop with Excel 97 (it
works when they run it on their mainframe which has Excel2000):

"Run-time error 1004 copy method of range class failed"

Is there any quick fix for this without knowing exactly where the macro
is
failing (I could find out if necessary -- the problem is I'd have to
walk the
user (who's not very proficient in computers) through this over the
phone.

Thanks!

Robert