4 ms·
So does excel VBA. But man, are arrays a pain in VBA.
by auxym 10y ago
So does excel VBA.
But man, are arrays a pain in VBA.
- eon1 10y agoWhy do you say so? I find them pretty easy to handle. Variant arrays can be pulled and pushed straight from/to Range objects, you have LBound and Ubound to iterate over arrays if you don't feel like you can trust the base, or otherwise you have For Each. And you have Collection and Dictionary if you have different needs - you can even define a class, instance it and push to a Dictionary, now you have a key-value store full of your Object.