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

See Chip Pearson's page on this topic:

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

--
Regards,
Tom Ogilvy

"charlieb" wrote in message
...
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

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" wrote in message
...
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

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/