I want to copy a range of Excel file to another file keeping the cell format.
I tried to with this Macro:
Sub CopyPast ()
Windows (“File 1.xlsx file”). Activate
Sheets (“File 1”).
Range ( “A1: F4”) Select.
Windows (“File 2.xlsx file”). Activate
Sheets (“File 2”).
Range ( “D5”). Select
the macro goes wrong at the line: Windows (“File 2.xlsx file”).Activate
Thanks for your help