Okay, so I should preface this by saying I've barely used VBA in my life and I've only used VB about 5 or 6 years ago.
But this didn't stop me spending 6 hours yesterday making an all singing all dancing data sorta me-do for Jane. Basically, it just creates a load of new sheets and sorts data into them. Along with a bit of prettyness and a neat options page. Finally, it adds a 'sum' row to the end of each sheet.
It remembers each sheets active row in an integer array:
CountryActiveArray()
and the names
CountryNameArray()
Of course, the positions are identical so that I can cross ref.
For some reason, no matter what I do, I can't get one of the outputs to evaluate. It's probably just as easy to show you - I've attached two instances of my break point. One which evalutes properly and the other that doesn't:
http://img.waffleimages.com/dcf407848b5e83167d2ae8935575014391cafe28/wrong.JPG
http://img.waffleimages.com/9ed4577a8de91a843c8351c0dae243377f3181c8/right.JPG
I suppose, logically, it's most likely that something in my code elsewhere is screwing it so if there's any way I can look deeper please let me know. The IF statement is only there to stop it from adding a sum row to empty sheets, cos it looks shit loike. |