Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I sometimes pull ranges into an array to save time (instead of looping).
Right now, I'd like to do the opposite- I have a complicated workbook and the code isn't working properly, so I need to see the array during processing (refreshed during a larger loop) to see what is going on. The problem is that while I can set a worksheet range equal to a 2D array, this particular array is 3D and there is only one slice of that I need to see (effectively a 2D slice) So what do I need to change in my syntax to go from the two dimensional assignment: Sheet1.range("A1:J100).value = TestArray to a slice of a 3D range, where TestArray(1 to 30, 1 to 100, 1 to 3) and I only need to see where the third parameter =2; Sheet1.range("A1:AD100").value = TestArray ([all],[all],2) Is this possible, and if so, how do I reference TestArray to get my desired 'slice'? Thanks for any assistance, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variant array with formula strings to range formulae | Excel Programming | |||
for each in range gives variant array | Excel Programming | |||
Write from variant array into range | Excel Programming | |||
Runtime error 13-- Setting a variant Range?! | Excel Programming | |||
Best way to paste a variant array into a range? | Excel Programming |