Writing values to worksheet from array
Doh!
Many thanks Tom
"Tom Ogilvy" wrote:
array(index1,index2)=cdate("10/08/2005")
--
Regards,
Tom Ogilvy
"interstellar" wrote in message
...
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?
|