LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 1004 Copy method of worksheet class failed Ayo Excel Discussion (Misc queries) 3 March 28th 08 02:05 PM
Run Time Error 1004 Copy method of Worksheet class failed Paul Hitchcock Excel Programming 2 May 4th 05 08:10 PM
Run-Time Error 1004 Copy method of worksheet class failed Don Lloyd Excel Programming 0 July 27th 04 07:27 PM
VB Error: Paste Special method of range class failed Chris Excel Programming 2 January 30th 04 12:51 PM
error 1004 Select method of Range class failed J.E. McGimpsey Excel Programming 1 September 12th 03 07:42 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"