Range.Select results in error if running macro from another workbook

  • Here's my problem, I have a very basic line in my macro:

    But, the macro gives me an "application-defined or object-defined error" if I run the macro from a different workbook, than the active one?

    I tested this, my macro swaps between two workbooks, and different Range.Select lines work if I transfer the whole macro to another workbook.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!