View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fid[_2_] Fid[_2_] is offline
external usenet poster
 
Posts: 16
Default Writing Single Dimension Array to Active Sheet

I have a single dimension array DataHolder(CellCount) where CellCount =
the number of items in the array.

I want to write the entire contents of the array to C1002 to Cxxxx on
the active sheet where xxxx depends on the length of the array.

I have tried

Range(Cells(1002, 3), Cells(1002 + cellcount, 3)) = DataHolder

but it writes the only value at DataHolder(1) in every cell instead of
all the values in the array.

What am I doing wrong?

Thanks,

Brent