Hi Gary

A is a column, not a Row.
1 is a Row
If you want to check that column A is empty then either
=COUNTA(A:A)=0 will return True if it is empty or false if it isn't
or
=COUNTIF(A:A,"<")=0
will do the same.

If you really did want a row, then
=COUNTA(1:1)=0

Obviously the formula cannot be placed in column A, or in row 1 for this
to work
--
Regards

Roger Govier


"GARY" wrote in message
oups.com...
If A1 contains no data (i.e., is empty), how can I make sure that all
other cells in row A contain no data (are empty)?