Going 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.

 

[Ms-Exl-Learner]

Try this...

Press F5 and in "reference:" type BB1 and give ok or Enter. The Cursor
will be moved in BB1 cell.

Like that type your cell reference to move to that particular cell.

 

[dhstein]

Thanks for the response - but that doesn't work. Depending on what the user
has been doing and where the cursor is etc. there may be other cells visible
to the left of BB1 and that's what I'm trying to solve.

David

 

[Jacob Skaria]

Try the below...Use the smallscroll and LargeScroll properties of the
ActiveWindow and adjust to suit..

Range("BB1").Activate
ActiveWindow.SmallScroll ToRight:=10

If this post helps click Yes

 

[Atishoo]

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

 

[dhstein]

Thanks that did it.

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