VBA just stops in Windows 7 but not Windows XP...

**UPDATE**
This actuall does fail in XP as well, after a bit more testing. So confused.
---

Hey folks,

So I've been scouring the internet since yesterday to try and figure out what the deal is with this, with no success. I have some code that, when run on my Windows XP machine in Excel 2010, executes flawlessly. On my Windows 7 (main) machine, however, when I get to any line that involves changing the Interior of a cell, the code executes that line, and then simply ceases. No error message, no nothing, the macro just stops running. At first I thought it was a problem with trying to tell a cell to be formatted in a way in which it was already formatted (I had had this issue with trying to tell a cell to have .NumberFormat = "$#,##0" when it already had that format), so I build in some if statements, which helped with the number formatting but now do not help on the following code:

Please Login or Register  to view this content.

It's ugly, I know. It was a lot cleaner when I had first written it; this is the result of me trying various means of solving the issue, but to no end. Any place in that code when I try to assign a value to x.Interior.<something>, the code will do so, and then just stop. Other than simply finishing this project on my XP machine (which isn't really a viable long-term solution as we're eventually all moving to Windows 7), can anyone offer some insight or suggestions as to what is going on and how to fix it?

Thanks,
Tom