Check cell color in 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…

Posted On

Add text to cell in Excel

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

Posted On

Excel Add text based on cell value

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

The function displays the value in the…

Posted On

VBA copy range

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

Posted On

VBA Sum function

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

Posted On