I had a call from a user the other day about a report that had stopped working.
I had a look at the VBA, not bad, but damn hard to follow (suck a loads of stuff into a random set of arrays of various dimensions, shuffle it and miraculously drop the right values into a range elsewhere.) well normally the right values – now it wasn’t working right.
I adjusted the caller parameters to fit a minor change in the data, tested it and had no clue if it was working. (It’s that type code that gives you no clue what its doing just presents the answer (Paul Daniels stylee)). I sat with the user to understand what it was meant to do. Lots of buggering around and a few back and forths, until it finally dawned on me:
The last few rows were being cut off by the print area!
Change the print area, user happy, ticket closed. Only about a bazilion hours longer than it should have taken – d’oh!
I truly can’t remember the last time I printed out a spreadsheet, and thats my excuse and I’m sticking to it.
Do you print out much stuff?