Tried this, the code to resize the range was included. I think the problem is
that Excel fails to interpret the data types correctly.
--
Tony Green


" wrote:

Just a thought, but the knowledge base article said an array of equal
size - given that you know the number of fields (columns) and the
number of records (rows) why not use these values to get the actual
size of the array and set the entire value at this point?