I need to write a macro that makes the code go one sheet to the right. Normally i would just select Sheets("Sheetname").select but this macro will be used to add more sheets in.

Any Ideas?