Run Time Error 9 " Script out of range

[vaibhav2312]

Dear Friends

I write below formula, but no luck getting Run time error 9, attached workbook for further information, getting error on underlined area

Please Login or Register  to view this content.

Thanks in advance
Vaibhav

[JosephP]

there isn't a sheet called Purchase Order in the purchase order data workbook

[vaibhav2312]

Sir,

i have already set

Please Login or Register  to view this content.

in purchase order data workbook

[AB33]

The error is not on this line

Please Login or Register  to view this content.

More likely on these two lines

Please Login or Register  to view this content.

[JosephP]

your subscript error occurs here

Please Login or Register  to view this content.

because there is no sheet called Purchase Order

[Andy Pope]

As JosephP said the workbook you open does not contain the sheet you are trying to reference.
Because you have not qualified the Sheets reference you will default to the activeworkbook.

You can use Thisworkbook reference to resolve that, you will need to use it in all lines of code, or create an object to reference the sheet as you have done for "PO Data".

Please Login or Register  to view this content.

[vaibhav2312]

Sir,

i want to copy

Please Login or Register  to view this content.

above range in to the following range

Please Login or Register  to view this content.

[vaibhav2312]

@ Andy Pope

Working Perfect.

Thank you so much