Home

Consulting

Excel VBA

Legal

Links

Contact

About Us

VBA

VBA stands for Visual Basic for Applications, which is a programming language or macros that comes built into Excel and other Microsoft Office products. It allows you to extend the power of Excel by having the computer do the work instead of you.

VBA is useful if you are doing repetitive and boring tasks with Excel. Much of this work can be automated so you can spend your time on more important tasks.

For example, recently we had a client that had about 30 spreadsheets and she wanted to count how many records existed on each of the 30 sheets which had about 20,000 rows each. She wanted to exclude rows where five different columns had either a zero or blank. To manually perform this task would have taken her about 3 days. We were able to write the VBA code to perform this task in about 30 minutes. Not only did it save her time, but not having to perform such a tedious task