I am using 2000 and I just tested this. It does not happen the same way for
me as it does for you. When I use countblank on a range that has formulas
that return "" if the cell they refer to is blank, then as soon as I delete
the cell that the above mentioned formulas refer to, the countblank increases
by 1. First I tried a countblank formula which was located on a row
underneath the range I was testing. I also tested it on a column/row which
was before the cells being tested and both times, the countblank updated as
soon as I hit delete.
--
Kevin Vaughn


"Ian P" wrote:

I've tried it in other worksheets (making sure that I use the delete key) and
I get the same result every time. If I put values in cells A1:A6 and then
use the formula =a1 in cell a18 and =a2 in cell a19 etc and then use the
=countblank(a18:a23) I get the result 0. If I then delete A1 I still get
zero. Press delete again and I get the result 1. Could someone else with
Excel 2000 confirm if this does the same for them?

Thanks

Ian

"Bob Phillips" wrote:

Are you sure that you are not clearing A21 with the delete key but hitting
the spacebar? Space looks blank, but is not.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Ian P" wrote in message
...
Has anybody encountered a problem with the countblank function? I am
using a
formula =if(a21="","",a21); =if(a22="","",a22) etc. I then use the
countblank function to count the number of blanks in this array. If I
delete
a21 then the formula delivers the blank cell but the countblank doesn't
increase. Weirdly, if I press delete a second time then the countblank
updates. I've checked the calculation options and everything seems to be
set
right so why would this happen?

Thanks

Ian

PS I know that it's easy to get round this by using other counts but I
wondered why the countblank function doesn't work properly.