Using keyboard shortcuts
To select to the next sheet in the workbook, press Ctrl+Page Down.
To select to the previous sheet in the workbook, press Ctrl+Page Up.
Using the mouse
To the left of the sheet tabs in the horizontal Scroll Bar are four small arrows.
1. Place the mouse pointer over one of the arrows and right-click.
2. From the shortcut menu, select a sheet from the list of sheet names.
Screenshot // Selecting a Sheet in the Workbook
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"Hello,
I'd like to move between sheets using VBA code. I want to search each sheet for the same data to find witch sheet it's on.
Ben "