Manipulating Arrays

[Alan Beban]

I have uploaded to the freely downloadable file at
http://home.pacbell.net/beban some additiional procedures for handling
3-D arrays, including a function to load worksheet ranges (and/or 2-D
arrays) into a 3-D array, and a sub procedure for dumping a 3-D array
onto a worksheet.

Alan Beban

 

[ilia]

Thanks Alan! Looks easy enough to work with and customize.

 

[Alan Beban]

Thanks Alan! Looks easy enough to work with and customize.

In the function Load3D, probably after you downloaded the file, I
changed the name to

Function Load3D(Base As Boolean, ParamArray iAreas())

and added after the line of code

ThreeD iAreas(0)

the line

ConvertBase iAreas(0), -Base, -Base, -Base

This allows the user to choose whether to load a 0-based or 1 based 3-D
array.

I've uploaded the modified form.

Alan Beban

 

[Alan Beban]

Thanks Alan! Looks easy enough to work with and customize.

BTW, I have no idea whether the 3-D functions, particularly Load3D and
Deposit3DArray, have any usefulness. Sometimes I just code them instead
of doing jigsaw puzzles or crossword puzzles, so I would be delighted to
get any feedback.

Alan Beban

 

[ilia]

I'll try them out when there is an occasion.

BTW, I have no idea whether the 3-D functions, particularly Load3D and
Deposit3DArray, have any usefulness. Sometimes I just code them instead
of doing jigsaw puzzles or crossword puzzles, so I would be delighted to
get any feedback.

Alan Beban

 

[Alan Beban]

I'll try them out when there is an occasion.

If you do have occasion to consider them, be aware of two other
functions: Save3DInNames and Load 3DFromNames. They avoid having to
define the place in a worksheet for dumping the array elements for storage.

Alan Beban