Select doesnt work in different sheet?

[miso.dca]

Hello,
I have this code

Please Login or Register  to view this content.

this of course works, but only If active sheet is MyB ... when I active different sheet, It doesnt work .. why? How could I fix it? Of course I can activate sheet MyB and then do this, but I'd prefer another solution, If there is any ... thanks !

[Andy Pope]

Please Login or Register  to view this content.

Remove the select and selection parts and execute as a single statement

[miso.dca]

great! thank you