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