<div>
<div class="content wysiwyg-content">
I have searched EE but cannot find the specific code I am looking for.<br />
<br />
Could an expert please provide me with code that will find the word Counterparty Code the delete all rows above it keeping the row with Counterparty Code <br />
<br />
Many thanks
</div>
</div>


I have searched EE but cannot find the specific code I am looking for.

Could an expert please provide me with code that will find the word Counterparty Code the delete all rows above it keeping the row with Counterparty Code 

Many thanks

Find a word then delete all rows above it

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