View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erche DP Erche DP is offline
external usenet poster
 
Posts: 8
Default 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!