PDA

View Full Version : Macro keeps crashing Excel!?!?!



scv109
05-06-2009, 09:15 AM
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?? :dunno:help

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...

shades
05-14-2009, 10:09 AM
Howdy.

Is this specific to Mac versions of Excel?

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

scv109
05-14-2009, 10:40 AM
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!

tpoynton
05-15-2009, 05:58 PM
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.

shades
05-18-2009, 08:10 AM
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.

mikerickson
05-26-2009, 03:49 PM
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.