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…

Posted On

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…

Posted On

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…

Posted On

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…

Posted On