Dump 5D VBA array to 2D excel array
 

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/

Dump 5D VBA array to 2D excel array
 

http://www.excelforum.com/t187896-s

Is this it.


Keith
www.kjtfs.com


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

Dump 5D VBA array to 2D excel array
 

Yes that is it. Sorry about that. Don't know how I missed that.
Thanks for the response.


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

Dump 5D VBA array to 2D excel array
 

This is strange. I cannot find that post when I search through th
site. I can only get to it through your url link. Whats with that

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

Dump 5D VBA array to 2D excel array
 

ExcelMonkey wrote:
*This is strange. I cannot find that post when I search through th
site. I can only get to it through your url link. Whats with that
*

That is strange do you have sometype of option set in user cp to no
show threads older than xx days or something like that??

Keith
www.kjtfs.co

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