Hi,
I am trying to create some statistical functions as an Excel add-in. These functions need to reference values from statistical tables. I would much rather put these tables into the vba code as static arrays, but I am stumped as to how to accomplish this. The statistical tables would be two dimensional arrays and would be static.
How does vba want the values in a two dimensional array entered? Specifically, the first of the tables is 26 rows by 50 columns. When dimensioning the array, does vba expect rows, then columns, or vice versa?
Assuming I am successful in this portion, I will have questions on how to pull specific values from the array analogous to vlookup or hlookup, if anyone wants to expound on those.
Any insight is greatly appreciated.
Thanks,
Dale
I am trying to create some statistical functions as an Excel add-in. These functions need to reference values from statistical tables. I would much rather put these tables into the vba code as static arrays, but I am stumped as to how to accomplish this. The statistical tables would be two dimensional arrays and would be static.
How does vba want the values in a two dimensional array entered? Specifically, the first of the tables is 26 rows by 50 columns. When dimensioning the array, does vba expect rows, then columns, or vice versa?
Assuming I am successful in this portion, I will have questions on how to pull specific values from the array analogous to vlookup or hlookup, if anyone wants to expound on those.
Any insight is greatly appreciated.
Thanks,
Dale