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?

Here's a link to samples using arrays to manage data. DataForms.xls
demos using sheet-based only. ColorNamesManager.xls demos using both
sheet-based data and storing that data in a text file. Look for
"DataArrays.zip"...

https://app.box.com/s/23yqum8auvzx17h04u4f

A new version of 'DataForms.xls' has been added to the zip archive
since posting the link. Follow that same link to update...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion