vba array logic
so i'm trying to teach myself how to do data manipulations in arrays instead of in the excel cells directly.
currently, i'm simply importing myrange into one large array, but i don't think this is the best way about it since myrange includes multiple data types (dates, $$$, strings, numbers/integers, etc).
Should i be using a unique array for each unique data type? ex - insteda of myarray() i would have datearray(), balancearray(), acctnumarray(), etc... so instead of one large two dimensional array i would have multiple one dimensional arrays. does this sound right?
|