Run-time Error '9'; Script Out of Range Error.

[MsJojo]

I am getting the above error, when running my code.

I have opened all of the Workbooks being referred to, so the code should be able to refer to it and run smoothly. But I"m getting an error code.

As an example, for "

Please Login or Register  to view this content.

,
it says 'wbSouceVarCBFulfil=Nothing'

It is the same errors and notification for the other Workbooks being referred to, too, for some reason.

Please Login or Register  to view this content.

[AlphaFrog]

Did you open the workbooks in the same instance of Excel as the workbook that has the code?