I thought I posted this last night but can't seem to find it. So at the
risk of double posting here goes again.

I normall dump a 2d VBA array to a 2d excel range. As they have the
same dimensions 13x9 its simple.


Range("ExcelRange") = VBAArray

However I have expanded the VBA array to 5 dimensions.

Redim VBArray (1 to 13, 1 to 9, 1 to 3, 1 to 5, 1 to 10)

But I sill want to dump the original 2d portion of this array into my
spreadsheeet to check the values as I built my routine. So wnat to
paste this 2d protion as I step through the remaining dimensions (i.e.
3,4,5,). Can I do this without a loop? I know Alan Beban has
functions that can do something like this. But considering I am using
5 dimensions, am I forced to use a loop?


---
Message posted from http://www.ExcelForum.com/