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 macr
will be used to add more sheets in.

Any Ideas

--
chalk
-----------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...fo&userid=2375
View this thread: http://www.excelforum.com/showthread.php?threadid=56327