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

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

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

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

Hi Norman,

Yes, the macro is run from a commandbutton. The only problem now is the
button is from the "Forms" toolbar so it is not an 'ActiveX' control (this
was done so the macro would work on Mac's as well as PC's) -- I can't seem to
access the same Properties that I can with an ActiveX control -- is there a
way for me to access the "TakeFocusOnClick" property of a commandbutton from
the "Forms" toolbar?

Thanks for your help!

Robert

"Norman Jones" wrote:

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

Hi Robert,

My suggestion related only to an activeX commandbutton and a forms button
does not have a TakeFocusOnClick property.

Having eliminated that possibility, it would be necessary to see the
problematic code.

---
Regards,
Norman



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

Yes, the macro is run from a commandbutton. The only problem now is the
button is from the "Forms" toolbar so it is not an 'ActiveX' control (this
was done so the macro would work on Mac's as well as PC's) -- I can't seem
to
access the same Properties that I can with an ActiveX control -- is there
a
way for me to access the "TakeFocusOnClick" property of a commandbutton
from
the "Forms" toolbar?

Thanks for your help!

Robert

"Norman Jones" wrote:

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

by any chance is code triggered by clicking a button on a form or worksheet?
If so, set the TakeFocusOnClick = False.


"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

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

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

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

Ha ha! Actually that is really bugging me - I've tried to figure out how to
change my screen name, but can't seem to find where I do that. When I go to
"Manage Your Profile", I can edit my name -- which is already correct -- but
there is nothing about screen name. Do you know where I can edit my screen
name?

Thanks!

Robert

"William Benson" wrote:

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