Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring a Date array to a range
I am having trouble transferring a Date array to a range.
In my XL sheet cells A1-A3 are pre-formatted as mm/dd/yyyy dates. MyDateArray is a two dimensional (3, 1) array containing dates, say all three are 05/11/2007. When I try Range("A1").Resize(1, 1) = MyDateArray(1, 1) this works perfect and puts 05/11/2007 in A1, but Range("A1").Resize(3, 1) = MyDateArray gives me three times 01/00/1900 01/00/1900 01/00/1900 in A1-A3. This is actually a much longer array and I prefer not to loop through all the elements. Is there a way to transfer it to the sheet at once without disturbing the dates? Thanks very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT with Date Range Array | Excel Discussion (Misc queries) | |||
Please Help: Transferring from Dictionary to Array | Excel Programming | |||
transferring array to range | Excel Programming | |||
Problem transferring array data onto worksheet using Resize | Excel Programming | |||
Transferring part of a multi-dimensional array to a range in VBA | Excel Programming |