Tuesday, April 05, 2011

Excel Macros -- Oy Vey!

I'm working on a project right now where I'm creating a VERY lengthy Excel Macro in VBA to recreate a spreadsheet in a specific format. It's definitely a learning experience since I've never messed with Excel Macros, but quite frustrating none the less. I'm now almost a month working on the project, and I can honestly say I wish I knew 4 weeks ago what I know now since I've had to recreate the same logic a few times as I'm learning more efficient ways to do it.

The biggest catcher now is getting IRR and XIRR to work in VBA.

No comments: