Ant the award for the most creative username on a Microsoft Forum goes to:

"Linking to specific cells in pivot table"

-----------------------------------------------
:-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-)
-----------------------------------------------


"Linking to specific cells in pivot table"
crosoft.com wrote in
message ...
Thanks for your help Bill!!

"William Benson" wrote:

Also, if you are using a command like Range("A1").copy instead of
ActiveSheet.Range("A1").copy ... try the latter ... or
Worksheets("MySheet").Range("A1").Copy, etc. I have seen Excel fail to
"know
where it is" sometimes. I do not have any real background as to why, just
used the workaround. Hope it helps, I am only trying because I saw no one
replying to you in past couple hours.

Bill
"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