Consulting

Results 1 to 5 of 5

Thread: Excel 2004 VBA Bug (Resolved w/SP1)

  1. #1
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location

    Thumbs up Excel 2004 VBA Bug (Resolved w/SP1)

    Here is the original thread

    http://www.vbaexpress.com/forum/showthread.php?t=253



    [Edited to reflect the larger nature of the issues.]
    Last edited by shades; 06-19-2004 at 08:09 AM. Reason: Change Title

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  2. #2
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location

    Thumbs down

    Well, nuts!!!! Again. After more experimenting the bug includes COPY, CUT, and PASTE.

    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.
    Last edited by shades; 07-02-2004 at 10:04 PM.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  3. #3
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    [Edited: the problem with not making copies of a worksheet was temporary.]
    Last edited by shades; 07-02-2004 at 10:05 PM.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  4. #4
    VBAX Tutor jamescol's Avatar
    Joined
    May 2004
    Location
    Charlotte, NC
    Posts
    251
    Location
    One thing to note - If you use pre-2004 shortcut key combos, I understand some of them changed in 2004. If you're using shortcut keys, verify they still work on '04.
    "All that's necessary for evil to triumph is for good men to do nothing."

  5. #5
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Good news, initial tests show that the SP1 for Office 2004 solves this copy/paste VBA issue:

    MS Office Updates Notice

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •