question about VBA and excel macros

Water Cooler
#1

How do I get my scripts to look at relative sheets instead of specifically named sheets? For example, I want it to go to next tab or previous tab, not go to “Profits” tab or “Expenses” tab?

#2

http://www.mrexcel.com/forum/excel-questions/45312-relative-sheet-reference-[solved].html