MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checking a range for data


Posted by Francis on October 18, 2001 1:17 AM

kind of function can I write within a module to find out whether a range has any data?


Posted by Aladin Akyurek on October 18, 2001 5:33 AM

=COUNTA(range)>0. (NT)

Posted by Juan Pablo on October 18, 2001 6:07 AM

Try using...

Worksheetfunction.CountA(Range("A1:A6"))>0

Juan Pablo