View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linking to specific cells in pivot table Linking to specific cells in pivot table is offline
external usenet poster
 
Posts: 64
Default Excel 97 error: 'Copy method of range class failed'

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