View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JackRnl JackRnl is offline
external usenet poster
 
Posts: 3
Default transferring array to range

A worksheet contains 10000 rows containing each 10 groups of (9 columns
of values PLUS 1 empty column).
I want to define a range for each group and load them into an (integer)
array. After performing some calculations and changing some values of
the array I would like to write the array back into the range.

How can I read the values into the array and how can I store the values
onto the range efficiently?