VBA Data Types

VBA can take care of data types automatically, but it does it at a cost of speed and memory. When your application grows,…

Posted On

Comments and Notes

Comments in Excel can be used to describe different cells in a worksheet, without changing their contents. You can use comments in many…

Posted On

Selecting Cells

Excel allows you to select cells in several different ways, using both the mouse and the keyboard. Selecting with a mouse by dragging…

Posted On

Variables

Because VBA is a programming language, it shares common principles and elements with other languages. One of them is variables. A variable is…

Posted On

Loops

VBA, as well as other programming languages, offers loops. Looping is an operation of repeating the same block of code multiple times. Excel…

Posted On

Conditional Statements

If you want your procedure to behave differently depending on the conditions it meets you have to use one of the conditional statements….

Posted On

The Macro Recorder

A popular method to create a macro is to use the Macro Recorder. When you use this tool, you show Excel (by clicking on…

Posted On

Introduction to VBA

In the ever-growing world of data analysis, efficiency is king. This is where VBA (Visual Basic for Applications) comes in. VBA is a…

Posted On