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….
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…
The range object in VBA represents a range of cells on a worksheet. It can consist of multiple cells, as well as a…
If you want to use the VBA code to open a workbook in read-only mode, you have to follow these steps. Open an…
In order to save a workbook in VBA, use Alt + F11 and enter the following code. Sub SaveWorkbook() ActiveWorkbook.Save End Sub…
In this lesson, I’ll show you two methods you can use to read files. The first one will read a file line by…