I currently us a 4D array to mirror an Excel database consisting of

Sorry but all I see is a one-dimensional array. Just because it's an array
of a custom type having multiple elements doesn't make it multi-dimensional.
But anyway, sure, you can change the type of any element and add all the
elements you want. In fact, feel free to experiment<g.

--
Jim Rech
Excel MVP