Posts by HopFrog

Five:

Solver Add-in and Inquire, which appears to be part of Office, Microsoft Power Map for Excel, Pivot for Excel, and Power View for Excel, plus one more that is part of a vendor/partner application.

Are you copying individual cells from a specified row/column to the end of the data set on the second sheet, or copying entire columns?

Are you copying the formula or just pasting the values? is formatting important?

For copy/pasting values, you could save the call to the UI by writing the value from one cell directly to another. For example:
Worksheets("sheet2").Cells(erow, 2).value = sheet1.cells(i,4).value

If you are referring to installed references, this is what I have:

When I open two workbooks and look at the Project Browser in the VBA editor, I see both workbooks in the list, as expected.

When I close one of the workbooks, the VBA instance remains visible. I expected it to disappear.

Has anyone seen this before??