If, by NULL, you mean blank (no data, no text, no formulas, no nothing),
try this:

=COUNTIF(A:A,"") will return 65536 if it is truly all blank. Of
course, use the letter of the column you want to verify.

Is this what you are looking for?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=470009