View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Hall NZ Andrew Hall NZ is offline
external usenet poster
 
Posts: 21
Default Concatenate / Select Subset of Arrays

My specific question relates to 2D arrays:

1. How to add say a new 10 column row to an existing array with x rows
already in it

2. How to create a new array from row 2 col 2 to row 6 col 8 from am
existing 10 x 12 array (pretty easy with a Range object).

Obviously I can do it by looping through the arrays and assigning values one
at a time but is there a better alternative.

Andrew