I want to be able to load data from a sheet as follows:
Dim x() as variant
x=range(....).value
This loads the rows & columns of range into x(i,j) just fine.
But I want to use/refer to the data in a custom structure, e.g.:
y(6).height
y(4).weight
etc.
Can I create an "equivalence" (Fortran style) between x & y so one
does not have to loop through x cell by cell, and then populate each
element of y?
I tried posting this in Excel Forums, but the responders did not
understand. Am trying again here.