Category: vba

Each color in Excel has its index. You can get both background and font color with a shortcode. Let’s use the following example…

You can add text to a cell using ampersand “&”. First, find a cell you want to add text to. Next, enter the…

To display text based on another cell, you have to use the conditional function IF.

The function displays the value in the…

There are a few ways you can loop through files in a folder. You can do it only for a chosen folder without…

The simplest way in VBA to check whether the cell is empty is by using the IsEmpty function. Take a look at the…

In order to convert a string to an integer in VBA, first, we need to check whether the string can be converted. If…

There are a few ways you can copy a range in VBA. For example, you can copy only values or entire cells, including…

As you know, you can use the SUM function or the autosum button to sum a range inside an Excel worksheet. But you can…

As you already know, rows in Excel are labeled with numbers, so it’s easy to get to that row by specifying a number….