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

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


On Nov 8, 3:09 pm, Alan Beban wrote:
I have uploaded to the freely downloadable file athttp://home.pacbell.net/bebansome 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 wrote:
Thanks Alan! Looks easy enough to work with and customize.


On Nov 8, 3:09 pm, Alan Beban wrote:

I have uploaded to the freely downloadable file athttp://home.pacbell.net/bebansome 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



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

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


On Nov 8, 3:09 pm, Alan Beban wrote:

I have uploaded to the freely downloadable file athttp://home.pacbell.net/bebansome 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



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

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

On Nov 8, 5:45 pm, Alan Beban wrote:
ilia wrote:
Thanks Alan! Looks easy enough to work with and customize.

On Nov 8, 3:09 pm, Alan Beban wrote:

I have uploaded to the freely downloadable file athttp://home.pacbell.net/bebansomeadditiional 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

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 wrote:
I'll try them out when there is an occasion.

On Nov 8, 5:45 pm, Alan Beban wrote:

ilia wrote:

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

On Nov 8, 3:09 pm, Alan Beban wrote:

I have uploaded to the freely downloadable file athttp://home.pacbell.net/bebansomeadditiional 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

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


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