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…
Category: vba
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.
|
1 2 3 |
Sub SaveWorkbook() ActiveWorkbook.Save End Sub |
This procedure will save the…
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…
VBA find last column
In this lesson, I presented a few ways to get the last column number. The first methods are easy, but then the code…
Count number of rows in Excel
In order to count rows in Excel, you have to use VBA code. Open VBA Editor with Alt + F11. We are going…
VBA sort columns in table
In order to sort columns in a table with VBA, you have to create one. This is the table we are going to…
VBA sort range
In order to sort data inside a range in VBA, you have to use the following code.
|
1 2 3 |
Sub Sort() Range("A1:A10").Sort key1:=Range("A1"), order1:=xlAscending, Header:=xlNo End Sub |
This code will give you…
