View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
charlieb charlieb is offline
external usenet poster
 
Posts: 1
Default Navigating cells in VBA

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