Copying rows from Subsidary Files To Mastersheet with Formulas

[Bob Phillips]

Volker,

Glad we finally cracked it.

Regards

Bob

Hi Bob,

the code will do the job.
I save many hours !
Thanks ...

Volker

Volker,

Sorry, I was being particularly dense. It's the same intrinsic problem as
before (must figure out why it worked in my test though!).

Change
.Range(Cells(iRow2, 1), Cells(iRow2, 5)).Copy _
Destination:=ThisBookMaster.Cells(iRow1, 1)
to
.Range(.Cells(iRow2, 1), .Cells(iRow2, 5)).Copy _
Destination:=ThisBookMaster.Cells(iRow1, 1)

Sorry for taking so long over it.

Regards

Bob

way