Home page

This site can help you to avoid writing the same VBA code every time.

vba helpers is an open source procedures / functions collection intended to solve general Excel programming tasks like: find the last row on a sheet or create new worksheet or change range's background color and many others.

The main idea is to hide some tricky parts of Excel VBA API and provide you a set of ready-made procedures / functions to be used. All the helpers supplied with parameters description and example of usage so you can easily apply them in your macros.

There are a few distinct search methods available for you: you can use the search page on the site or you can search and import helpers right from Excel. If you not sure where to start consider use categories which were designed to help you on a particular scope of tasks.