Macro to change worksheets in the same workbook

J

James C

I am in sheet 1. I need a macro that will move me to sheet 2.
Can someone provide the code?

Thanx!

- Ji
 
S

swatsp0p

How will you trigger the code? Button? Keystroke? Other method?

More info, please.

The basic line of code is:
Sheets("sheet2").Select
where "sheet2" is the name of your sheet 2
 
Top