<div>
Try <br />
<br />
copy the good rows to a new sheet <br />
delete the original sheet<br />
rename the new sheet to the original sheet
</div>


Try

copy the good rows to a new sheet
delete the original sheet
rename the new sheet to the original sheet

<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015

<div>
<div class="content wysiwyg-content">
I have tried several of the vba solutions posted here on EE but they all take a long time to complete. The file I have has over 300,000 rows of data and I need to delete every row that has a zero [i.e. where it = 0] &nbsp;in column 'B'<br />
<br />
Many thanks
</div>
</div>


I have tried several of the vba solutions posted here on EE but they all take a long time to complete. The file I have has over 300,000 rows of data and I need to delete every row that has a zero [i.e. where it = 0]  in column 'B'

Many thanks

What is the best and quickest vba code to delete large amounts of data

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

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.