changeing date formats when not intended

Hi,
I use this piece of code to copy data from one place to another
Range("B" & 11 + (iRowCounter * iCount) & ":D" & 10 + (iRowCounter * (iCount
+ 1))).Value = Worksheets("extract").Range("A16:C" & 15 + iRowCounter).Value

one of the values is a date which is in the dd/mm/yyyy format in the source
but at the destination it is mm/dd/yyyy even when it says it is not.

How do I stop this from happening

MarkS

have you tried with
Value2 property iso Value?

that way you circumvent dateconversion and or formatting
problems

read vba help on Value2 for specifics



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


MarkS wrote :

> Hi,
> I use this piece of code to copy data from one place to another
> Range("B" & 11 + (iRowCounter * iCount) & ":D" & 10 + (iRowCounter *
> (iCount + 1))).Value = Worksheets("extract").Range("A16:C" & 15 +
> iRowCounter).Value
>
> one of the values is a date which is in the dd/mm/yyyy format in the
> source but at the destination it is mm/dd/yyyy even when it says it
> is not.
>
> How do I stop this from happening
>
> MarkS