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/yyyy![]()
Set Ws1 = Workbooks("worksheet1.xls").Sheets("Copy From") Set Ws2 = Workbooks("worksheet2.xls").Sheets("Copy To") Ws2.Range("A1", "K5") = Ws1.Range("A1", "K5").Value
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