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
