Category: vba

I’ve already written about removing rows in Excel, that contains the specific text. In this lesson, I’ll show you have to achieve this…

If you have a worksheet with the same data in adjacent cells, you may want to merge them for visual reasons. In this…

Different languages have different syntaxes for nested if statements. In this lesson, I’m going to show you, how you can use multiple if…

Here, I’m going to show you a few ways to get the last row using the VBA code. Find the last row in…

In this lesson, I’ll show you how to create a VBA macro to check whether the string contains a letter or a string….

If you have a large amount of data and you want to find text values and distinguish them from the other types of…

The vlookup function is used to lookup and retrieve information from the selected column in a table. If you used this function, you…

You can’t use regular expressions by writing an excel formula, but you can do it with a bit of VBA code. Follow these…

In VBA, you can create your own data types using the Type keyword. It’s very similar to struct data type from other programming…

With the Cells property, you can reference any object inside a worksheet, where you can make changes or retrieve the value. This is…