Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a simple!?!? piece of code which grabs data from a 2d array: MyCell.value=array(index1,index2) The problem occurs when there's a data - Excel seems to flip the day and month. eg where array(index1,index2)="10/08/2005" MyCell.value="08/10/2005" I've tried reading the value to a string - the same happens, formatting the string - the same happens, reading the value to a date -the same happens, formatting the date - the same happens. Where am I going wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet Function to Create Array of Size n with values x Through | Excel Discussion (Misc queries) | |||
Array Pasted from One Worksheet Converts Null Values to Zeros | Excel Discussion (Misc queries) | |||
(Newbie) Copying values from an array to the worksheet | Excel Programming | |||
Array of Values from Worksheet Range - What does it 'look' like? | Excel Programming | |||
Writing Array Formulas in VBA | Excel Programming |