Hi Brent,

Fid wrote:
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.

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.

If you use Application.Transpose to transpose your array, it should work:

Range(Cells(1002, 3), Cells(1002 + cellcount, 3)) = _
Application.Transpose(DataHolder)

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]