Hi

Start your macro with this line:

Application.ScreenUpdating=False

And this line before "End Sub"

Application.ScreenUpdating = True

If you need further advise, show us your code!

Regards,
Per
"Gerardo" skrev i meddelelsen
...
I have a macro that runs quite fast when the Visual Basic code window is
open. But if it is closed takes a few minutes.

The macro reads one sheet and writes a in a second one when new data is
found for the report, I know is faster to read all data, fill up an array
and
then write it all at once.

Any ideas?