how to Delete unfiltered (hidden) data from excel 2010 using VBA
<p>I am new to this blog and request you all to help me on the below code. Currently I am trying to select the criteria (based on list of unique codes) and delete the unfiltered data which i am unable to do. Hence request the add on programme for this. Thanks    </p>

<pre><code>ActiveSheet.Range("A5:K125000").AutoFilter Field:=11, Criteria1:=EngID
ActiveSheet.Range("A5:K125000").Select
ActiveSheet.Rows("A5:K125000").EntireRows.Hidden.Delete
ActiveSheet.Rows.Hidden = False
</code></pre>