Macro copy from one Wb to another error

[luke_p]

Hi all,

I've inherited the below code which copies from one workbook to another.
However, the highlighted section in the code below, i think, assumes the data is in the first worksheet of the source book.

How do i get around this because the sheets i want to copy from is called "Actuals Exps" (which in Vb is sheet 3).

Thanks L

Please Login or Register  to view this content.

[Leith Ross]

Hello luke_p,

Instead of using the worksheet's current position index, use the name.

Please Login or Register  to view this content.

[luke_p]

Leith,

Thanks for the quick reply, have done what you suggested by got the following error;

"Run-Time error 9" Subscript out of range

and the line changed is highlighted

Please Login or Register  to view this content.

[Leith Ross]

Hello luke_p,

The subscript out of range error means that either the worksheet doesn't exist or the name is incorrect. Make sure the correct source workbook is open and the worksheet name what is in the code.

[luke_p]

Leith,

You're absolutely bang on mate.

Thanks again for your prompt reply.