Sign In
Register
Help
Has anyone had problems running macros using the new Excel 2004 for a Mac? Even something simple like...
Range("A1").Select
Selection.Copy
...will cause an error message on the 2nd statement (Run-time error '1004' Copy method of Range class failed).
I've been using Excel on both Macs and PCs for years and have written & run extensive procedures without problems.
Any ideas?
Thanks,
Jay
Page 1 of 1
Excel 2004-Visual Basic Problem
MultiQuote
#2
shades 
- Member
-
- Group: Members
- Posts: 344
- Joined: 28-June 02
Posted 10 June 2004 - 05:24 PM
Interesting because I have just been trying out many of the macros that I had developed for Excel 2002 (Win 2K). Except for a few call procedures all worked well.
But I tried your example and ran into the same error, and haven't found a way around it yet.
But I tried your example and ran into the same error, and haven't found a way around it yet.
#3
shades
- Member
-
- Group: Members
- Posts: 344
- Joined: 28-June 02
Posted 10 June 2004 - 05:40 PM
I checked on the MS Newsgroup for Mac Excel,
http://support.micro...;EN-US;newsgmac
And John Gordon, MVP indicated that it is a serious bug. I submitted an error report. You should probably do the same.
http://support.micro...;EN-US;newsgmac
And John Gordon, MVP indicated that it is a serious bug. I submitted an error report. You should probably do the same.
#4
JDeitch
- Newbie
-
- Group: Members
- Posts: 5
- Joined: 04-January 04
Posted 11 June 2004 - 02:39 AM
Thanks for checking this out. It's nice to know the problem isn't just with my installation.
I've tried an older VB procedure as well. There is a button on the worksheet that is tied to the macro. It seems to run fine if I click on the button (although a little slower than before), but if I open Visual Basic and run the macro from there, it quits on "Selection.Copy."
Again, thanks for verifying this.
Jay
I've tried an older VB procedure as well. There is a button on the worksheet that is tied to the macro. It seems to run fine if I click on the button (although a little slower than before), but if I open Visual Basic and run the macro from there, it quits on "Selection.Copy."
Again, thanks for verifying this.
Jay
#5
shades
- Member
-
- Group: Members
- Posts: 344
- Joined: 28-June 02
Posted 19 June 2004 - 05:07 AM
Well, nuts!!!! Again. After more experimenting the bug is bigger than I originally thought.
1. The good news is that if I don't step through the macro, but just run it from the worksheet, then the copy/paste method works fine. The bad news is that this bug applies to Cut method as well.
2. Even worse, there is no way to make a copy of the worksheet!! Yep. CTRL + Click the worksheet name, and select MOVE OR COPY..., the dialog box appears, and shows each worksheet, and the option to "Create a copy..." When that is checked and clicked OK, nothing happens. I tried it from the Edit menu as well. Nothing!!
1. The good news is that if I don't step through the macro, but just run it from the worksheet, then the copy/paste method works fine. The bad news is that this bug applies to Cut method as well.
2. Even worse, there is no way to make a copy of the worksheet!! Yep. CTRL + Click the worksheet name, and select MOVE OR COPY..., the dialog box appears, and shows each worksheet, and the option to "Create a copy..." When that is checked and clicked OK, nothing happens. I tried it from the Edit menu as well. Nothing!!
#6
JDeitch
- Newbie
-
- Group: Members
- Posts: 5
- Joined: 04-January 04
Posted 13 October 2004 - 02:39 AM
Followup:
I just installed Office 2004: Service Pack 1 and tried the same simple macro. It seems to work fine. Obviously this isn't an exaustive test, but it looks promising.
Can anyone confirm?
Thanks,
Jay
I just installed Office 2004: Service Pack 1 and tried the same simple macro. It seems to work fine. Obviously this isn't an exaustive test, but it looks promising.
Can anyone confirm?
Thanks,
Jay
Page 1 of 1
