Need help debugging an Add-In that sometimes works and sometimes doesn't

Hi all,

I'd be very much obliged for any help anyone can provide in solving this issue: I have an add-In that I'm using in Excel 2010 which reformats the data in a spreadsheet. The raw data is exported from a trading platform into Excel. The trading platform is periodically upgraded/updated by the vendor and it seems like every time they do so, they change how the raw data is formatted. So, every time I upgrade the trading platform, I also have to tweak the add-in. On this last go-around however, things didn't go 100% and now sometimes the add-in works well and sometimes it doesn't. When it doesn't work, Excel seems to get stuck/frozen in some kind of loop. I then have to break the loop/close Excel. Upon doing so, I get a brief popup error message ("Runtime error -2147417848 Method 'cells' of object_'Worksheet' failed") and then Excel crashes.

I can't figure out why this is happening, and furthermore what baffles me is why the macro works fine on some data but then craps out on other data sets, even though the data is always formatted exactly the same way when it gets exported from the trading software into Excel.

I've attached an example of a spreadsheet that causes the problem, and I've also attached an example of a spreadsheet that works just fine.

Unfortunately it looks like I can't attach the .xla add-in file to this post (and can't use WinZip on this computer either, so can't Zip and attach it), and the actual code exceeds the character limit for a post, so I'd have to email the .xla to anyone who might be interested in helping.

thanks,
Phil

Originally Posted by Alf

You could try to rename the ".xla" to ".xls" and then test if it's possible to upload. If so you must add a comment so that forum members know they have to rename it back to ".xla" in order to test.

Alf

Hi Alf,

I renamed the add-in to .xls and attached it. It's called CQG Blotter Converter v148804. Don't forget to rename to .xla after downloading. Thanks.