Consulting

Results 1 to 6 of 6

Thread: Macro keeps crashing Excel!?!?!

  1. #1
    VBAX Regular
    Joined
    Mar 2009
    Location
    PA
    Posts
    6
    Location

    Macro keeps crashing Excel!?!?!

    Hey Guys! You really helped me out before and I was hoping you could help me again! I put together a complex macro that seems to always crash my excel. I can't figure out why! Can you review to see where I am going wrong or what I am missing??

    Thanks so much for your help in advance!

    The code was attached, when using the vba labels I would lose my entire post. sorry for the inconvenience...

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

    Is this specific to Mac versions of Excel?

    If so, what version of Excel? What system are you using?

    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
    VBAX Regular
    Joined
    Mar 2009
    Location
    PA
    Posts
    6
    Location
    Thanks for the reply!

    I'm using Mac OS X 10.5.6 with excel 2004 installed. I am completely stumped on this.....

    Thx again!

  4. #4
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location
    That is a lot of code...you should check out the article here at http://vbaexpress.com/forum/showthread.php?t=9882 to make things more efficient, which might help. Otherwise, try running short bits of the sub to narrow down the point at which it crashes.

  5. #5
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    What happens when you step through the procedure? What line causes it to crash? Are all the bits of code usable on the Mac version? In other words, it has to be compatible with Excel 97. Some code that is used in XL 2000/2002/2003 will not work in XL 2004.

    Unfortunately (?) I no longer have any version of Excel, so I can't help you investigate.

    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

  6. #6
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    I haven't looked at the code, but what is it doing?
    I have weird 2004 crashing issues with code that maipulates VB components
    AND some issues with UserForms. (Multi-select ListBoxes in particular, but others as well.)
    I've also had issues with UF/Class code where a syntax error will crash Excel rather than bring up the Debug alert.

Posting Permissions

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