Hi

I tried to use code below, but when the data array is date , no work fine

Code:
Dim lMyArray(2, 1) As Longl
MyArray(0, 0) = format(now,"dd/mm/yyyy")
MyArray(0, 1) = format(now +1,"dd/mm/yyyy")
MyArray(1, 0) = format(now +2,"dd/mm/yyyy")
MyArray(1, 1) = format(now +3"dd/mm/yyyy")
MyArray(2, 0) = format(now +4,"dd/mm/yyyy")
MyArray(2, 1) = format(now +5,"dd/mm/yyyy")


XLSheet.Range("D7:E9").Value = lMyArray
In Excel date show all column as "0/1/1900"
Why ?

I see code in http://www.vbforums.com/showthread.php?t=391665 for other data
work fine