Problems with running VBA in 2011 Excel

[JVBeaupre]

I was happy to learn that VBA was coming back to 2011 Excel.
But some of my heritage Excel workbooks with VBA macros, bomb out with
Runtime Error 6, overflow. For the most important workbook, all the
values in the debugger highlighted line seem normal and in bounds.
Some modules approach the upper size limit of previous VBAs, but have
always run flawlessly on 2004 for Mac & 2007 for Windows Excels.
Does anyone know why this might happen?

 

[Steve Maser]

I was happy to learn that VBA was coming back to 2011 Excel.
But some of my heritage Excel workbooks with VBA macros, bomb out with
Runtime Error 6, overflow. For the most important workbook, all the
values in the debugger highlighted line seem normal and in bounds.
Some modules approach the upper size limit of previous VBAs, but have
always run flawlessly on 2004 for Mac & 2007 for Windows Excels.
Does anyone know why this might happen?

Because the VBA code was not well tested, unfortunately.

I have a small number of bugs with code that works in Excel 2004 (and
2010) that bombs out in Excel 2011 (one that springs to mind is you
can't save a file with a long name...).

Make sure you document and file these bugs!

One of the better places to file the reproducable VBA bugs is on the
forums at mactopia.com -- they have engineers reading the blogs and --
on occasion -- indicate they've been able to reproduce the problem and
have put it in their bug tracking system.

- Steve