Displaying active cell in upper left corner

  • Thread starter Thread starter neopolitan
  • Start date Start date
N

neopolitan

When selecting a range by name, if the range is not in the cells
displayed at the time, Excel then shows the first cell of the range at
the bottom of the display. This is also true if I have hyperlinked to
a particular cell as in an index.

How do I get the active cell shown at the upper left corner of the
display instead? :)
 
Sub setscroll()'no need to activate first
ActiveWindow.ScrollRow = [a5].Row
End Sub

This is probably what you are looking for.
Sub setscroll_a()
[e7].Activate
ActiveWindow.ScrollRow = ActiveCell.Row
ActiveWindow.ScrollColumn = ActiveCell.Column

End Sub
 
Thanks, Don. I took the one line of code and put it into a Worksheet
Selection.change procedure so that when I select a cell in this one
specfic workbook, the cell is displayed at the top of the screen. The
particular worksheet has an index of hyperlinks at the top. These
hyerlinks are to other cells farther down in the sheet. So this keeps
me from having to scroll down to find a particular cell!:D

Thanks for the help.
 
Back
Top