Aug 07 2022 05:14 AM
I have 6300 rows and I want to search in this data with multiple criteria Is it possible arrays help me in this work . if i Filling a 2-dimensional array with a one-dimensional array or make multiple dim array
Aug 08 2022 03:22 AM
i need help @adnan2004
Aug 08 2022 04:00 AM
Please try to explain as clearly as you can what you want.
Aug 08 2022 02:03 PM - edited Aug 08 2022 02:04 PM
Excuse me, can you explain to me this sentence in this link?
https://stackoverflow.com/questions/39821883/vba-3-dimensional-array
(" The practical way storing the data is to have a 1D array filled with 2D arrays. This will allow you to use standard techniques to work with thee data.")
Aug 08 2022 02:16 PM
SolutionWhile VBA can easily handle three-dimensional (and higher) arrays, Excel cannot store them directly: a worksheet is a two-dimensiona array of rows and columns.
The reply on Stack Overflow proposes to create a one-dimensional array - think something like {item1, item2, item3, ...} in which each item is a two-dimensional array. So item1 would be an array of rows and columns, item2 would be another array of rows and columns, etc.
Each of these items can be stored on a worksheet.
But I don't see how this relates to the question in the first post.
Aug 09 2022 02:42 AM
Aug 09 2022 03:05 AM
I'm afraid I don't understand what you want to do. Could you try to explain that clearly and in detail?
Aug 09 2022 03:53 AM
Aug 09 2022 03:59 AM
Anyone else?
Aug 08 2022 02:16 PM
SolutionWhile VBA can easily handle three-dimensional (and higher) arrays, Excel cannot store them directly: a worksheet is a two-dimensiona array of rows and columns.
The reply on Stack Overflow proposes to create a one-dimensional array - think something like {item1, item2, item3, ...} in which each item is a two-dimensional array. So item1 would be an array of rows and columns, item2 would be another array of rows and columns, etc.
Each of these items can be stored on a worksheet.
But I don't see how this relates to the question in the first post.