Excel Copy/Paste Range goes very slow

I’m Using the activity Copy/Paste Range for copying 1000 lines from one sheet to another.
The activity works but it takes a long time (35 minutes)

Do you know what is the issues?
Is there another activity to copy cells to another faster?

Thanks in advance.

Hi, welcome!

Typically we use the Read Range activity followed by a Write Range activity to transfer data from one sheet or workbook to another.

However if your workbook has fancy formatting, things can get a bit tricky. Otherwise this method is very solid and quite fast.

Happy automating