MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!!