Thread: vba array logic
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Dyer Matthew Dyer is offline
external usenet poster
 
Posts: 178
Default 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?