application.activewindow issue

Hi

I have wrriten a macro which sits inside one workbook and should look at the second open workbook and go into one of the sheets and add column headers to the columns.

However when it runs it keeps produing a "Type Mismatch" error

Please Login or Register  to view this content.

Does anyone know why this is happing?

Thanks

Jeskit

This:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

since you declared the variable as a Workbook, not a Window.

Hey! I actually noticed that! I must be learning something here.

Then the sheet name is incorrect. Perhaps there's a space in there?

If the error occurs there, then the sheet name is wrong.
Also, you are assigning both sheets to the same variable...

If the error occurs on one of those two lines (and it would be helpful to know which one) then:
EITHER the sheet name is incorrect;
OR the wrong workbook is active when you run the code.

That doesn't change my answer.

The active workbook is whichever workbook is active (i.e. visible in the Excel window) when you run the code. If it should always refer to a specific workbook, refer to the workbook name instead of assuming it's the active one.