Is is possible for a macro to copy a range of cells from one file to the
same
range in another file?

Yes, but you have to have some way to know which workbook is which. How do
you know which is the source and which the destination?

--
Jim