Dear WAMUG members,

I recently sent an Excel file, designed using Excel X (MS Office X), which
contains some simple VBA scripts. The scripts work well on my Mac, but it
did not on a PC running Win 98 and Excel 2000 when the following error
message was returned:

"Runtime error'1004' : Paste method of Worksheet class failed"

I have previously run various spreadsheets, designed on my Mac, and which
contained VBA scripts without any problem on my work PC running Win NT, and
also Win 2000.

Is this sort of error expected? My knowledge of VBA is very basic ....

Although I do not see any relevance to this problem, but just in case it
does  my computer is a G5 Dual 1.8mhz running OS X v10.3.6 and using Office
X. 

Many thanks for any ideas.

Regards,

Philippe