<div>
Thanks it worked great!! -R-
</div>


<div>
<div class="content wysiwyg-content">
I have a dataset that already has some columns filtered (another procedures exit point) &nbsp;and now need another column filtered and if there is a result (usually is) delete all rows that are greater than zero.<br />
<br />
The column is AC, so I need to add to the existing filter, the deleting of all rows greater than zero. &nbsp;There has been times when there has not been any zeros to filter by, but there has always so far rows greater than zero.<br />
<br />
Is this possible, if a filter already in place? &nbsp;Please advise and thanks. -R-
</div>
</div>


I have a dataset that already has some columns filtered (another procedures exit point)  and now need another column filtered and if there is a result (usually is) delete all rows that are greater than zero.

The column is AC, so I need to add to the existing filter, the deleting of all rows greater than zero.  There has been times when there has not been any zeros to filter by, but there has always so far rows greater than zero.

Is this possible, if a filter already in place?  Please advise and thanks. -R-

AutoFilter Delete

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.