ok I figured out the Counter

for i = 1 to 10
code here
next i


Now how can I go to the next work sheet, assuming I have 150
worksheets?

thanks


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=557473