Thank you: that's not nearly as horrible as I expected it to be...
...Said an Excel developer.
I work on two levels: what's an elegant solution in coding terms; and the ugly questions about how it's actually going to compile and run. The overriding concerns on planet Hairyears are clarity and ease of maintenance - if it was performance, it wouldn't be in VBA! - but sometimes, I need to know what I'm doing, and what's being done for me. And some of *that* is horrible, through and through.
Which in turn means that understanding loops is more than merely coding them, and further reading - like this stuff - is essential.
...Said an Excel developer.
I work on two levels: what's an elegant solution in coding terms; and the ugly questions about how it's actually going to compile and run. The overriding concerns on planet Hairyears are clarity and ease of maintenance - if it was performance, it wouldn't be in VBA! - but sometimes, I need to know what I'm doing, and what's being done for me. And some of *that* is horrible, through and through.
Which in turn means that understanding loops is more than merely coding them, and further reading - like this stuff - is essential.