I am trying to copy entire “sheet1” from “Wbk1” to “sheet2” in “Wbk2”.
I can do it with read and write range, however the formatting of the dates in “Wbk2” are gone.
e.g. “13/09/2017 22:00:00” in custom formatting (dd/mm/yyyy hh:mm:mm) is copied over to Wbk2 as “13/09/2017 22:00” in text format.
Is there a way to read and write range while keeping the formatting of each cell?
You could create a macro for changing the format. Then select the cells to be formatted and Execute Macro.
Or you can find some other suggestions in this thread: