How to select a cell in another worksheet

Ok, first off, the easy question.

There has got to be more elegant solution to this (I hope). If I want to select a cell in another worksheet I'm currectly doing this:

Please Login or Register  to view this content.

Is there a format that will select the sheet and cell number together?

Please take a few minutes to read the Forum Rules about thread titles and code tags, and then edit your post to have a descriptive title and code in tags.

Thanks for following the rules

You should avoid selecting if you can. If you tell us what you're trying to do there may be another way

If you have to select then you could try

Please Login or Register  to view this content.

VBA Noob