hey...

fyi...

at the moment i got 2 sheets that has a row (B23:T23) where the user needs
to enter closing stock. (a couple of colums are blank(future use)Sheet2
O:T). in the workbook i got a couple modules. one of them Clear the cells
that need to be cleard and then cary the closing stock over to the column for
the next days opening(B5:T5).

what i need is a code that i can put at the start of my existing code that
will check
if range b5 = something (product name/" ") then if b23 = "" msgbox "unable
to clear".
if range c5 = something (product name/" ") then if c23 = "" msgbox "unable
to clear".
if range d5 = somthing (product name/" ") then if d23 = "" msgbox "unabale
to clear".
etc

in a nutshell the user should not be able to print and clear the workbook
if a column got a product name(B5:T5) with a blank closing(B23:T23).
(and told in a msg box all the products names with a blank closing)


--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm