That's great Dave - thanks! - it works! So now how would I specify th
worksheets that it looks at if I don't want the macro to look at ever
worksheet in the workbook to check the value before printing that shee
or not?



Regards

Davi

--
davy
-----------------------------------------------------------------------
davyb's Profile: http://www.excelforum.com/member.php...fo&userid=2640
View this thread: http://www.excelforum.com/showthread.php?threadid=39677