Re: Copy Data Range From 1 Workbook To Another
hi tqv1969,
you can add a clean up code after each wkbk is opened:
here's a sample code, you can customize it further:
Code
Sub cleanUp()
Sheets("Sheet2").Activate
Cells.UnMerge 'unmerge all cells
For Each cell In Range("A1", Range("A65536").End(xlUp))
Select Case cell = "SELECTION CRITERIA:"
Case True
cell.EntireRow.Clear
End Select
Next
End Sub
hth