If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DCR" wrote in message ...
I need to count the number of orders that have not been reviewed yet. I
have been using countblank(O43:O5687). this works as long as some one
updates the formula when new orders are added. I am thinking I want a macro
that will find the last row using the order number in column A , then count
the blank cells in column O for order review, and also count the blank
cells in column t for outstanding orders.

Thanks
Clayton