What's your definition of "Blank"?

Is it an unused *empty* cell,
OR
a cell that appears empty but contains a zero length text string ( "" )?

Then, what is the formula you're trying to use?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"marklg" wrote in message
...
How do I discriminate between a blank cell and a zero value cell in a
formula?