Excel VBA Error Code 424 Object Required

Hi

I keep getting an error message on the macro I have built but I am not sure why. I keep getting the error "Object Required".

I have built a macro whcih uses the list in the current workbook to open two documents and then loop through the list and find the cell content in A:A of the first document opened and paste it into the second document open. The macro opens the two documents however when it comes to activating the first workbook (which contains the macro and list) it brings up this error.

Please Login or Register  to view this content.

I have highted the line it debugs on and produces the error.

Can anyone explain why it produces this error?

Thanks,

Jeskit

Remove the Activate part. I would also use:

Please Login or Register  to view this content.

rather than Windows.

No - Windows returns a Window object and Workbooks returns a Workbook object. They are not the same thing. Also, Activate doesn't return anything.

A workbook can have more than one window open on it (so you can view multiple sheets at the same time).