Thanks very much that works really well!

Only thing is I can't use data validation with data from anothe
worksheet like it says in that link but thats not a problem as I ca
just change the page break to print what I want.

Thanks
-turner200

--
turner200
-----------------------------------------------------------------------
turner2000's Profile: http://www.excelforum.com/member.php...fo&userid=1477
View this thread: http://www.excelforum.com/showthread.php?threadid=26441