Hello, I have over 2 years of Excel VBA macro development experience. I've developed automated Excel workbooks for different distribution companies, my last work is the workbook that collects the data entered on different sheets, performs heavy validation on its integrity based on data gathered from other workbooks, and provides different reports along with validation warnings and working reports on a separate sheet. The workbook also had a couple of sheets intended for setting up different validation logic and choosing the sheets (cities and regions) to process.
Having a strong Java experience (over 10 years), I love to apply OOP paradigms to my VBA code as well, as far as VB language allows it. Doing this allows to make macro code more clear, robust and maintainable.
Talking about performance, I prefer to read the source sheet data into memory first, then process, and then flush to the target rather than reading cell by cell, because it dramatically increases the processing speed.