select method of range class failed error

You can't select a range unless the sheet it's on is active.

However, you don't actually need to select, try this.

Please Login or Register  to view this content.