changeing date formats when not intended

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :
 
Back
Top