VBA range.row
The Range.Row property returns the number of the first row in the selected range. To illustrate you this we are going to select…
Category: vba
VBA Delete a Row if the Cell Contains
I’ve already written about removing rows in Excel, that contain specific text. In this lesson, I’ll show you have to achieve this with…
Merge Cells With the Same Values
If you have a worksheet with the same data in adjacent cells, you may want to merge them for visual reasons. In this…
VBA Multiple IFS
Different languages have different syntaxes for nested if statements. In this lesson, I’m going to show you, how you can use multiple if…
VBA Find Last Row
Here, I’m going to show you a few ways to get the last row using the VBA code. Find the last row in…
VBA Check if a Cell Contains a Letter or String
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 Cells Contain Text Then Use Formatting
If you have a large amount of data and you want to find text values and distinguish them from the other types of…
Conditional Formatting in Vlookup in Excel
The vlookup function is used to look up and retrieve information from the selected column in a table. If you used this function,…
Excel VBA Find and Replace Regex
You can’t use regular expressions by writing an excel formula, but you can do it with a bit of VBA code. Follow these…
Excel VBA Type
In VBA, you can create your own data types using the Type keyword. It’s very similar to struct data type from other programming…