set range object in inactive worksheet

[chouston]

I'm getting a run-time error '1004' application-defined or object-defined error on the the Set invoiceRange

I don't get what's wrong...

Please Login or Register  to view this content.

Full Code

Please Login or Register  to view this content.

[efernandes67]

Hi,

I believe that the ranges below are missing a number each. Something like Range("E4:E200") and Range("A2:A300").

Please Login or Register  to view this content.

I hope this is it or explain with more detail what you are trying to accomplish.

Regards,
Elio Fernandes