Category Archives: Excel

For Loops in VBA and the Continue Statement

Loops in VBA Loops are an essential part of any programming language because they help with the repeated running of any code snippet. Just like any other language, VBA offers the following loops to enable efficient programming: Do until Do while For Foreach In this

How to Use UsedRange in VBA (Examples)

Used Area of an Excel Sheet There are many situations when we need to perform an action on all rows and columns with data in an Excel sheet. In order to do that, you need to know which row/column of data is the last. In

How to Use IfError in VBA and Excel

Errors Happen We may come across several functions in programming languages. In VBA, we are prone to encounter errors like:  Syntax errors Compile time errors Runtime errors These are errors in code which can be handled using error handling methods. For example, you can see

No Thumbnail

Using VBA Like to Compare Strings

What is a Regular Expression? How is the Like Operator Related? In any programming language, there is a way to compare strings against some patterns. Several characters are used to create these patterns. These patterns are called regular expressions. Like in structured query language, VBA

How to Use the Boolean Data Type in VBA

Introduction to Flag Options in Programming In any programming language, there’s a need to set a variable to options like on/off, true/false, yes/no. This variable is then later used in the code to check or understand something else. For example, let us imagine that we

Using the Match Function in VBA and Excel

What is a Match Function? The match function in MS Excel is one of the useful built-in lookup functions that work like Vlookup, Hlookup, and the Index function to return the position of exact or similar matches of the lookup value found in an array

Use Any Formula: Worksheetfunction in VBA

Formulas in EXCEL Microsoft Excel offers several built-in functions that can be used as formulas in Excel worksheets. It displays the categories of functions available in the Insert Function window, as seen in the image below: Usage of Formula in an Excel Sheet Just like