Hi all,
I am trying to create a 3D array with VBA and then store the data in a "named range" to use it in one of my formulas. However, I don't seem to get it working. I have three named ranges on my worksheet, so each of them should represent an "area" and each of these areas contain 8 rows times 4 columns.
Below the code I have so far:
Once the array has been added to the workbook as a "named range" called "Cluster", I want to access the data by using an INDEX formula as below, where 1 = row 1, 2 = column 2, and 3 = area 3. Hence the result should be 52 as it refers to the second column, first row in range "KNITS".
Bookmarks