Problem with dates when writing a VBA array to Excell

[jjhenry]

I writing a VBA varinat array to Excel, I have a date column in the array formatted UK date. When I write it to Excel it is in US format. I do the same thing on a diferent sheet and it works fine. Even if I change the format of the cells after writing in the array the format does not change. The VBA code is

.Activate
.Range(Cells(pprow + 1, 1), Cells(pprow + UBound(DayData, 2), 10)) = Application.Transpose(DayData)

Any ideas
Thanks
Jason

 

[Shamen]

Excellent! It works.
Do you have any idea about the second question, how to insert an entire row of values into an array in one step?

Thanks a lot, Rory

 

[RoryA]

You should use an array of arrays, or loop.

 

[kvsrinivasamurthy]

Try this

Dim Ary() As Variant

Ary = Range("G9:N9")