How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.
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, then it will create a 2d array by default. If you would like to convert Excel range to Array of […]