I have written a vba macro that takes dates from two seperate workbooks and pastes them into a new workbook.
the 2 source workbooks both have the date format as dd/mm/yyyy, and the workbook they are being copied into also has that format set for the date cells.
however, when the dates are transferred, they display as mm/dd/yyyy, even though the format of the cell is dd/mm/yyyy.
Any ideas on what I am doing wrong?
Visit my site: http://www.drybonesuk.com