Hello,

I run a copy routine on the daily basis, involving hundreds of Excel files
over many hours (one file gets opened, a corresponding files opened, cells
copied, save and close, next). The macro contains the following lines:

With Workbooks.Open(nam_1)
.Worksheets(1).Cells.Copy Destination:= _
fil.Worksheets(myVal).Cells
.Close
End With


Do you think I would be able to speed up the whole process if I do not copy
Cells (whole sheets), but UsedRange? Or Range("A1:Z" & last cell)? Or use
Resize?
Thanks. All the best,
Yarroll

YES.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Yarroll" <(E-Mail Removed)> wrote in message
news:c6arvg$kvu$(E-Mail Removed)...
> Hello,
>
> I run a copy routine on the daily basis, involving hundreds of Excel files
> over many hours (one file gets opened, a corresponding files opened,
cells
> copied, save and close, next). The macro contains the following lines:
>
> With Workbooks.Open(nam_1)
> .Worksheets(1).Cells.Copy Destination:= _
> fil.Worksheets(myVal).Cells
> .Close
> End With
>
>
> Do you think I would be able to speed up the whole process if I do not
copy
> Cells (whole sheets), but UsedRange? Or Range("A1:Z" & last cell)? Or use
> Resize?
> Thanks. All the best,
> Yarroll
>
>