Agent Incorrigible's blog post - In your face Excel VBA!
Saturday, June 25, 2011, 6:31:29 AM
I am not a professional programmer. Everything I know about Visual Basic and VBA has been self taught when I have a spare moment.
So it has always been a lot of fun when I work out a solution/upgrade to a VBA project that I maintain for former employer.
I finally figured out a work around to automate a process that I've been manually updating for the past couple years. It has been a mildly annoying roadblock that never irritated me enough to actually sit down and work it out. Most of that was due to the fact I only had to work on it two or three times a year.
This year has been a little different. A lot of the hard coded data is changing monthly, so working out this process saves me a ton of headaches with error-checking.