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