changeing date formats when not intended

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
 
K

keepITcool

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

International Date formatting 4
Different Date formats in text to be recognised as date value 8
VBA: Copy a date and paste as text 4
Today's Date 1
Combine Two Different Worksheet_Change codes 9
Find a date in list less or equal than target date 4
Formatting from CopyFromRecordset 0
Problem with date formatting 5

Top