We use Lbound and Ubound function to find the length of an array.

To find a length of an array we need to declare the array first.

There are few things which we need to keep in mind for VBA Array length as follows: Step 6: When we run the code we get the following result, Step 5: Now use the Msgbox function to display the size of the array. Y = UBound(Dept, 2) - LBound(Dept, 2) + 1 X = UBound(Dept, 1) - LBound(Dept, 1) + 1 Step 4: Now use Lbound and Ubound function to find the size of an array as follows.ĭim Dept(1 To 6, 1 To 2) As String, x As Integer, y As Integer Step 3: Now similarly declare an array and two different variables as integers.ĭim Dept(1 To 6, 1 To 2) As String, x As Integer, y As Integer End Sub

Now we can start writing the code by declaring a Sub Function. Step 2: Double click on the module we just inserted which will open code window for us. Step 1: Enter VB editor by going in the developer’s tab and then clicking on visual basic as follows, Let us try to find out the size of this array. Now the data has one more rows from the above example 2.

Now let us try to find the size of an array in another example. Now we can check from the data it has 5 rows and two columns and each cell has one data so total there are 10 data. When we run the code we see the following result, Step 7: Now run the code from the run button or press F5. MsgBox 'This array Has ' & x * y & ' Data' Step 6: Now let’s use the Msgbox function to display the size of the array from the data above. Y = UBound(Grades, 2) - LBound(Grades, 2) + 1 X = UBound(Grades, 1) - LBound(Grades, 1) + 1 Step 5: Now as we have a size of the array we give an upper and lower limit to the dimension by the following code.ĭim Grades(1 To 5, 1 To 2) As String, x As Integer, y As Integer Step 4: Now first we need to declare an array for our data above and two another integers as follows.ĭim Grades(1 To 5, 1 To 2) As String, x As Integer, y As Integer End Sub Step 3: Now we can start writing the code by declaring a sub-function. Step 2: Click on insert tab and add a new module. We will follow similar steps from example 1 on how to enter the VB editor as follows. In the above screenshot, we have an array and we want to find the size of this array in VBA. We will use the traditional Lbound an Ubound method to find the array length. In the above method, we used arr.length method which is not ideal in many cases. Step 6: When we run the above code we get 16 as output as 16 is the length of the integer. writeline and arr.length function to find the array length as follows. Step 4: Now declare an array as an integer as follows. Step 3: Double click on the module we just inserted which will open code window for us. Step 2: Once we are inside the VB editor let us insert a new module which will open code window for us. Step 1: Enter VB editor by going in the developer’s tab and then clicking on visual basic as follows.

Get array length in pug template