Re: OT: my day
I've been working on an Excel VBA routine for the past week, and have been ripping my hair out with it - it's the first time I've ever used VBA in any way and it is VERY different to what I'm used to (I think in C/C++ terms). So, ok, I learned the basics, writing some code for the past week, real basic stuff...and it doesn't work AT ALL.
Just found out why: REAL stupid mistake. I was using COLUMNS, ROWS (like Excel does when you use it as a spreadsheet app) rather than ROWS,COLUMNS (like VBA does when you use "Cells" properties).
I blame bill gates.
Still a real embarassing mistake. And I have no excuse for wasting at least three days trying to figure it out.
|