I suggested a self adjusting defined name range to use in the formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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