Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Beginners' Question : How to move selected columns & rows to a two dimensional array
Hello Alan, what i want is to have all cells value on selected range per iteration can be filled into two-dimension array. so, in the first iteration, the range is d4 : e34, to the cells value within that range supposed to be filled on the array. the next iteration, the array will be cleared (0 value) and then range g4 : h34 will be filled in to that array. and so on... somehow, i was trying to use the .column and .row, because i cannot add the first range (d4) with some integer just to have the next column to be processed..... hope this' clear enough... thanks, *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Beginners' Question : How to move selected columns & rows toa two dimensional array
What does "and so on" mean? First D4:E34; then G4:H34 (no Column
F?); then what after G4:H34? Alan Beban Erche DP wrote: Hello Alan, what i want is to have all cells value on selected range per iteration can be filled into two-dimension array. so, in the first iteration, the range is d4 : e34, to the cells value within that range supposed to be filled on the array. the next iteration, the array will be cleared (0 value) and then range g4 : h34 will be filled in to that array. and so on... somehow, i was trying to use the .column and .row, because i cannot add the first range (d4) with some integer just to have the next column to be processed..... hope this' clear enough... thanks, *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Beginners' Question : How to move selected columns & rows to a two dimensional array
no column f in my description... so on means for every iteration... i think the pattern already shown.. first iteration : D4-E34 (means two columns 30 rows) second iteration: G4-H34 (means the second two cols 30 rows) third... J4-K34... anyway, back to the problem.. how to specify the range.. ? should be add-able... ??????? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Beginners' Question : How to move selected columns & rows toa two dimensional array
I don't recall anything in your posts that specifies how many
iterations; the following loads the contents of d4:e34, g4:h34, j4:k34, then m4:n34 Sub testab2001() Dim arr(), rng As Range, i As Long Set rng = Range("d4:e34") For i = 1 To 4 arr = rng.Offset(0, 3 * (i - 1)).Value 'do something Next End Sub Alan Beban Erche DP wrote: no column f in my description... so on means for every iteration... i think the pattern already shown.. first iteration : D4-E34 (means two columns 30 rows) second iteration: G4-H34 (means the second two cols 30 rows) third... J4-K34... anyway, back to the problem.. how to specify the range.. ? should be add-able... ??????? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Advanced Filter: How do you MOVE the selected rows... | Excel Worksheet Functions | |||
newbie question on multi-dimensional array | New Users to Excel | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) | |||
Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
Beginners' Question : How to move selected columns & rows to a two dimensional array | Excel Programming |