Navigating cells in VBA

[charlieb]

Is it possible to navigate to a specific cell on a sheet and have that
active cell always appear at the top left of the window. I have
several spreadsheet on a single tab. Using an index page, i want to
select an item and go to a new tab and put a specific spreadsheet
exactly in the center of the window. It appears that VBA places the
requested cell randomly in the window. THANKS in advance for the help
Charlie

 

[Tom Ogilvy]

See Chip Pearson's page on this topic:

http://www.cpearson.com/excel/zoom.htm#center

 

[Don Guillett]

try this
You could tie to a sheet_activate event to make it automatic

Sub gotoandscrollrow()
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollColumn = 3
End Sub

 

[charlieb]

Thanks to everyone for the suggestions. Both did the job. Appreciate the
help
Charlie