Jason Zischke Wrote:
Hi erikhs

Try This

ActiveWorkbook.Sheets(x)

"x" Refers to the Tabs at the bottom

e.g. :

If your looking for the third sheet along the bottom the "x" equals 3.

Jason Zischke


[/color]

Thank you for your suggestion, but how can i incorporate this into a
loop?
Any ideas?


--
erikhs
------------------------------------------------------------------------
erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788
View this thread: http://www.excelforum.com/showthread...hreadid=562405