Category: Collection

Showing all 3 articles in this category.

2020-01-16

VBA - Add Items to Array - Dynamic Resize without erasing data

How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to ...

Read Tutorial →

2020-01-18

VBA - Create Array from Excel Range - 1 Dimension

Excel Macro - Create 1D Array from Vba Array This is one of the easy methods to initialize an array . If you convert data in worksheet directly to vba array, th...

Read Tutorial →

2020-01-18

Excel Vba Sort Array - Quick Trick using built in function

VBA Array Sort - Using Excel Sort In this page, we have given a Excel vba code snippet that works well for sorting array of 1 dimension. You can also customize ...

Read Tutorial →