Running Macro on a Different Worksheet

I'm using VBA to find the row under LastRow and then clear the selection.

Please Login or Register  to view this content.

The code works perfectly, but only on the current worksheet. Is it possible to do this on another worksheet without having to go to that worksheet and run another macro?

In this case it would be 'Sheet1 (2)'


Thanks!!

Nevermind. I figured it out.

Please Login or Register  to view this content.

Try prefacing the code with the sheet in question

Please Login or Register  to view this content.