just wondering if anyone has seen this
this happens in all cases, but here is an example:

i loop through about a dozen workbooks, opening, copying some data to a
report workbook, and closing it.
if i load the report wb and run the macro, it takes maybe 3 seconds to
complete.
once i load the vb editor and close it, it takes about 7 seconds. so, this
is not run when the vb window is open.
closing the workbook and re-opening it doesn't speed it up, only closing
excel and running the macro before opening the vb editor speeds it up.

only have 5 references in vba:
vba
excel 11 obj lib
ole automation
office 11 obj lib
ms forms 2.0 obj lib

any ideas?

--


Gary