| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Array (multiple columns) Question
I'm trying to create a dynamic array of data.
I had previously dimensioned at the top of my sub the following: Public ItemArray(10,7) As Variant This gets me what I want, but only for 10 entries. I may actually have 50 entries. How do you dimension an array such that the amount of entries changes / is dynamic? The array is currently inside of a loop for items, and I want the array to update as below with each item. Hopefully this is enough information to piece together what I'm looking for. Thanks, Neil ItemCount = ItemCount + 1 ItemArray(ItemCount, 0) = ItemName ItemArray(ItemCount, 1) = AAvariable ItemArray(ItemCount, 2) = BAvariable ItemArray(ItemCount, 3) = CAvariable ItemArray(ItemCount, 4) = DAvariable ItemArray(ItemCount, 5) = EAvariable ItemArray(ItemCount, 6) = FAvariable ItemArray(ItemCount, 7) = GAvariable |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Question with multiple dynamic variables | Excel Worksheet Functions | |||
| Offset code for dynamic row# & multiple columns in LINEST function | Excel Worksheet Functions | |||
| Dynamic multiple-condition array function with more than one name | Excel Worksheet Functions | |||
| UDF to sort array with multiple columns | Excel Worksheet Functions | |||
| Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
Threaded Mode
