View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.E. R.E. is offline
external usenet poster
 
Posts: 1
Default Efficient Code to Copy a 1-D Array to a Worksheet Column

1-D arrays do not have a transpose.
P.S. Copying the data from the 1D array into a 2D array does work, but is
adds efficiency due to the extra copy step. Using single-dimensioned,
zero-based arrays is recommended for best performance in general.