brodaddy2002
Board Regular
- Joined
- Jan 21, 2013
- Messages
- 67
I am trying to separate a 2D array of integers into multiple 1D array of integers. Does anyone know how to do that? I looked into the split, join functions, but they work with strings. I guess that I could convert my integers to strings, and put some sort of delimiter in it. The main reason I would like to do this is because of the worksheetfunction.sum(arg1). My individual arrays have to some up to something.
The only other option I can see is to use a dictionary or collection with the arrays as containers. That would probably work as well, but I just wanted to hear your thoughts on getting splitting up a 2D array into smaller array. I have been able to do this using pointers in C, but am not sure if it can be done in VBA.
The only other option I can see is to use a dictionary or collection with the arrays as containers. That would probably work as well, but I just wanted to hear your thoughts on getting splitting up a 2D array into smaller array. I have been able to do this using pointers in C, but am not sure if it can be done in VBA.