checking a range for data
Posted by Francis on October 17, 2001 6:56 AM
What kind of function can I write to find out whether a range has any data?
Posted by Aladin Akyurek on October 17, 2001 6:59 AM
=COUNTA(A1:A10)
or
=IF(COUNTA(A1:A10),"Yes","No")
Aladin
Posted by Francis on October 18, 2001 1:16 AM
I need a function to use in a module!!
