Presumably at least one field in the record will always contain data.
Include that field in the extraction, count the records in that column,
then delete the unnecessary column.

Charley Kyd wrote:
After running the AdvancedFilter method with the xlFilterCopy action, how
can I reliably identify the result set?

Normally, there wouldn't be a problem. But I came across a result set where
the last item was an empty cell. There's a difference between returning, (a)
nine results, and (b) ten results, the last of which is blank.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html