I think we're getting crossed wires here.

Let me remove this confusion from this previous post by rephrasing it

xlRng.Value = vntDataArray


the contents of the fourth and fifth element of the variant array is


vntDataArray(3) = '04/12/1995'
vntDataArray(4) = '05/12/1995'
and so on

but after the assignment


xlRng.Value(3) = '#12/04/1995#'
xlRng.Value(4) = '#12/05/1995#'
and so on

Hope this clarifies it.


It's as if the Value property of the Range object is performing some
sort of conversion
in Excel 2003 whereas with Excel 97 it didn't.