Forum Discussion
Best practice for VBA/Macros in Excel
Hi Everyone, I am just starting a project to review complex spreadsheets that contain a lot of VBA and Macros. Is there some best practice around on this? A lot of what people are using is old, ...
It really depends on what you're looking at. If you are pretty familiar with VBA you can just look at the code and it will "speak to you". It's always good to comment code. I can't tell you how much time it's saved me when reviewing past projects. It's a pain to do, but you'll be thankful later. If you supply some of the code I'll be happy to review a bit of it for you. You can pretty much tell if someone really knew what they were doing at a glance.