Run-time error '1004' - code failing when on a different sheet

[bishoposiris]

I'm running the following code:

Please Login or Register  to view this content.

The code works fine as long as I'm on sheet Level1. But if I'm on a different sheet I get the error: Run-time error '1004': Select method of Range class failed. I have a userform on a different sheet with a button that calls this procedure. I want to run this procedure and switch to sheet Level1 AFTER it has run. How do I do that?

[Olly]

Which line of code causes the error?

[stnkynts]

Off the top of my head I would guess this line is the issue:

Please Login or Register  to view this content.

I could be wrong though.

[bishoposiris]

Please Login or Register  to view this content.

[stnkynts]

You can't select a range on a non active sheet. That line doens't do anything anyways so delete it and see what the next errored line is.

[bishoposiris]

Deleted it and the next error was on the next range selection. I'll just activate the worksheet before the first range selection.

Thanks.

[bishoposiris]

Deleted it and the next error was on the next range selection. I'll just activate the worksheet before the first range selection.

Thanks.