I am using something like this to copy data from one workbook to another
One of my columns is a date field, formatted using Custom dd/mm/yyyyPlease Login or Register to view this content.
After using this macro the date in the copied data is mm/dd/yyyy even though the receiving cell is formatted the same.... WHY?!?!?
Bookmarks