LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More if then logic DJ Excel Worksheet Functions 2 October 8th 09 05:37 PM
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) Keith R[_2_] Excel Programming 3 November 13th 07 04:08 PM
Understanding the logic and criteria of Array formulas Starguy Excel Worksheet Functions 2 April 29th 07 02:34 AM
Array Formula Using Max Match Logic JR573PUTT Excel Discussion (Misc queries) 4 February 26th 06 05:09 AM
If Then logic not enough workerbeeVAB Excel Discussion (Misc queries) 4 January 5th 06 05:24 PM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"