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!