2017-12-06
Excel VBA - Convert Range To Array - 2 Dimentional
VBA Range to 2D Array These list of topics are covered in this page. Vba Code to initialize 2D Array with Range Vba to write Array data to worksheet Resize Arra...
Category: Data Type
Showing all 10 articles in this category.
2019-12-04
Excel VBA Dictionary Datatype - Create & Add Keys, Items
Excel VBA Scripting.Dictionary "Dictionary" is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available dat...
2019-12-07
Excel VBA - Loop thru all Keys & Items in Dictionary
Dictionary Object - Accessing all Keys & Items In this article, You can get code to access a Dictionary object key & item in a loop. There are 5 different metho...
2019-12-23
Excel to XML Converter - Vba Code - Microsoft Dom
Get VBA Code to Convert Excel to Xml Vba code in this page reads table data by each row and adds it to Xml dom element. Once all the cell values are added, it i...
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 ...
2020-01-17
VBA Array Initialize Values - Split string to array
How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array w...
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...
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 ...
2020-08-19
LET( ) Function in Excel
What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate res...
2021-09-01
VBA to Change File Encoding ANSI to UTF8 - Text to Unicode
How to change Text encoding from ANSI to UTF8? If there are multiple txt files or programatically you need to change the encoding of a file from ANSI to UTF8 or...