Range Copy fails in any macro

[Aaron Graham]

Hi-
We have a spreadsheet solution that has been running on Mac Office
since Excel 97. We are currently trying to update it for Office 2004
Compatibility and have run into a MAJOR issue. When ever we try to do
a range copy we get a runtime error '1004' Copy method of Range class
failed. I have tried creating a new WB, with no links on a fresh
install and fresh reboot and it fails, even trying selection.copy in
the immediate window fails. We have tried this on 3 separate
machines. Could someone please test this for me?


1.) create new WB
2.) go to VB Editor
3.) open immediate window
4.) type and execute selection.copy

Thanks.....

 

[Jim Gordon MVP]

Hi Aaron,

Unfortunately I think this bug crept in at the last minute.

Please take a moment to send your comments to Microsoft. Use the Feedback
feature from Excel's help menu.

Obviously this is a serious bug and will need to be corrected right away, so
please be sure to send the feedback immediately.

Thanks.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

 

[Jay Deitch]

I have the same problem. A simple macro like...

Range("A1").Select
Selection.Copy

....wil stop on the second statement if I run the macro from Visual Basic. If I
launch the macro from a button on a worksheet it works. I tried a new
workbook as well as an older one created using Office X with the same
results.

Jay

 

[Aaron Graham]

Any new news on when this will be patched? I sent a Feedback message in
but never got an answer, not sure if anyone ever does. Is there any
other way to find out details if/when this is going to be fixed?

 

[JE McGimpsey]

Any new news on when this will be patched? I sent a Feedback message in
but never got an answer, not sure if anyone ever does. Is there any
other way to find out details if/when this is going to be fixed?

You most likely won't get feedback unless there's a question or a need
for followup.

I do know that that MacBU is aware of the problem.

How and when the fix will be issued is something that is never released
for understandable reasons: an immense amount of testing is required to
make sure that the fix didn't break something else, and prematurely
announcing the method and release date, then missing or extending it
causes even more disruption and mistrust. In my own work, I prefer to
keep my clients more up to date, and risk having them be upset that I
missed a deadline, but I have fewer customers to support by several
orders of magnitude - the dynamics are different.

 

[Jim Gordon MVP]

Hi Aaron,

I can't tell you when there will be a patch, but I can tell you that when
there is one, there are new features in Office 2004 that could be used to do
the update.

Office 2004 has a new auto-update feature. Be sure to use the Help menu to
"check for updates" and then schedule it to run daily.

Updates will install automatically. You no longer have to go to Microsoft's
web site and download updates.

It might be a while before there's any update, though. When they fix
something they have to test lots of things to make sure that the fix doesn't
break something else.

You rarely receive a direct reply from Microsoft if you use the Feedback
feature from the help menu. Nevertheless, issues sent in via that method are
tracked in a Bug database and that is the surest way to make sure a manager
sees the comments.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info