Using Autofilter to filter blanks and numeric values
<p>enter code hereI am completely new to vba and I am preparing a macro for automating daily activity reports. Part of the report is filtering the data based on certain values and copying it in another workbook.
I'm stuck here and need your help.
column x has "Names of customers", but there might be Blank fields, Dates and ID numbers.</p>

<p>I figured out filtering blank fields but not able to find how to filter dates &amp; ID numbers or in general numerics.</p>

<p>this is the code I'm using:</p>

<pre><code>range("A1").AutoFilter field:=21, Criteria1:=Array(""), Operator:=xlFilterValues
</code></pre>

<p>dates can be 5/28/2016
id numbers can be 292051102901</p>

<p>I have searched for similar posts but could not find it.</p>

<p>Please let me know if additional code needs to be shared or a sample file to work.
<a href="http://i.stack.imgur.com/Y0mCF.jpg" rel="nofollow">Snippet of data</a></p>