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
|