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….
Category: vba
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 lookup and retrieve information from the selected column in a table. If you used this function, you…
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…
Cells and Range property in VBA
With the Cells property, you can reference any object inside a worksheet, where you can make changes or retrieve the value. This is…
VBA range set value
The range object in VBA represents a range of cells on a worksheet. It can consist of multiple cells, as well as a…
VBA open workbook as read-only
If you want to use the VBA code to open a workbook in read-only mode, you have to follow these steps. Open an…
VBA Save as
In order to save a workbook in VBA, use Alt + F11 and enter the following code. Sub SaveWorkbook() ActiveWorkbook.Save End Sub…
VBA read a text file
In this lesson, I’ll show you two methods you can use to read files. The first one will read a file line by…
