<div>
Apply a filter to the data and Column H filter so only &quot;Closed&quot; is visible.<br />
<br />
Select the visible rows or even just one column of visible rows and delete. The rows hidden by the filter will be unaffected.<br />
<br />
Thanks<br />
Rob H
</div>


Apply a filter to the data and Column H filter so only "Closed" is visible.

Select the visible rows or even just one column of visible rows and delete. The rows hidden by the filter will be unaffected.

Thanks
Rob H

<div>
Thanks for the assist it works great...
</div>


<div>
The chosen answer resolves the issue considering the original requirement was to delete the rows based on a condition through VBA not with manual steps.
</div>


The chosen answer resolves the issue considering the original requirement was to delete the rows based on a condition through VBA not with manual steps.

<div>
<div class="content wysiwyg-content">
I know how to delete a row in Excel with VBA, but where I am struggling is how to delete rows if a certain condition is met. &nbsp;For example for any row where Column H (Status) is = to 'Closed' then I wish to delete these rows. &nbsp;Suggestions ?
</div>
</div>


I know how to delete a row in Excel with VBA, but where I am struggling is how to delete rows if a certain condition is met.  For example for any row where Column H (Status) is = to 'Closed' then I wish to delete these rows.  Suggestions ?

How do I delete rows in MS Excel VBA if a condition is met

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.

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