How to select a cell in another worksheet

[Zathrus]

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:

Sheet1.Select
Range ("a1").Select

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

[shg]

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.

[VBA Noob]

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

Application.Goto Reference:=Sheet1.Range("A1"), scroll:=True

VBA Noob

[Zathrus]

Sorry, noob to the board here.

The more I fiddle with this the more I realize just how over my head I am.