efficient code to copy/paste
Hi Ivano,
I missed the .xls extension from the
destination file.
The suggestion should, therefore, read:
Workbooks("Workbook.xls").Sheets _
("Benefit Analysis - Salary"). _
Range("A6:F19").Copy _
Destination:=Workbooks("Workbook2.xls").Sheets _
("Benefit Analysis - Salary").Range("A6")
---
Regards.
Norman
|