No, I cannot use an autofilter.  My intent is to programatically copy only
those records that meet my criteria to an alternate location, effectively
eliminating entries that are null.  Using autofilter, I would need to
determine the number of entries in the filtered list, then copy them to the
alternate location.

After repeated tries to find appropriate criteria to accomplish my goal, i
found that using
<>
in the criteria field works.  I enter it without quotes.

Thanks for your reply.