Category: vba

You probably already know that VBA (Visual Basic for Applications) is an amazing tool to use to automate processes in Excel. It is…

By now, you are probably aware of all the good things that you can you with VBA. Everything that is possible by using…

Everything that we can achieve by using „standard“ Excel, can be achieved by using VBA. One of these things is certainly Conditional Formatting….

One of the most useful tools in Excel is tables. They are a fantastic tool to present our data. It would be pretty…

When dealing with Excel tables, we can often forget how naming conventions and their grouping can be useful in our work. In the…

A lot of problems the users can have in Excel relate to the formatting of the numbers and values. One of the most…

So far, we mainly discussed Modules when we talked about the VBA. But, if you have ever dealt with Visual Basic in Excel,…

Although Excel itself is a great tool for automating the work that we would usually do manually, VBA is even better and more…

We have already discussed the role of VBA and its usefulness in Excel. VBA is a legacy program that Microsoft originally used to…

Visual Basic for Applications or VBA for short is a programing language of Microsoft Office Programs. Most of the people that use it,…