VBA has no tools for working with dynamic arrays. I propose a simulation of a two-dimensional dynamic array - based on the object: a one-dimensional array of one-dimensional arrays. Used ...

VBAで、いくつかの項目を配列に入れたいとき、まずDimで配列を宣言して、次にmyList(0) = ..., myList(1) = ...と、一行ずつ値を代入していく…。この方法、少し手間がかかると感じませんか？ あらかじめ中身が決まっている、比較的小さな配列を、もっとシンプル ...

Abstract: Multidimensional arrays are one of the fundamental computing abstractions to represent data across virtually all areas of science and engineering, and beyond. Due to their ubiquity, ...