How to read and write range from one workbook to another while keeping cell formatting?

Hi there,

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?


1 Like

Hi @yjkim

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:

1 Like