Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multidimensional Arrays - VBA
Tom,
Thanks very much for your help, but I think I have confused everyone, including myself. What I want to do is create a virtual table via an array of 151 rows and 6 columns. I have worked out the whole thing of writing in the array, ie setting up the virtual table, but I am not sure how to access it, I need to be able to get a certain value, check whether it appears in a certain column and if it does display the information from another column. ie Virtual Table One Cat Apartment Two Fish House Three Cow Flat And if the read in value is "Fish" I want it to output "House" I hope this makes it all a bit more clear. Thank you all for your help it is much appreciated, this is my first time using Multidimensional Arrays. Yours sincerely, Brent McIntyre *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of IF with arrays | Excel Worksheet Functions | |||
How can I write multidimensional arrays in Excel Formulas? | Excel Worksheet Functions | |||
using linest excel function from msaccess with multidimensional ar | Excel Worksheet Functions | |||
Arrays | Excel Discussion (Misc queries) | |||
Multidimensional Arrays - VBA | Excel Programming |