Go to a specific cell

[dhstein]

I want to have a macro that's goes to a specific part of the spreadsheet -
for example BB1. But I want BB1 to be in the left corner of the window. If
I just Select the cell it might not do that. How do I go to that cell and
ensure that the window is correct - the cells to the left of BB1 are not
visible. Thanks for any help on this.

 

[Atishoo]

Application.Goto reference:=Range("A2"), scroll:=True

 

[Atishoo]

Application.Goto reference:=Range("bb1"), scroll:=True