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?