<div>
I'm not sure what you mean by counting rows. What do you want to count, the empty rows, the non-empty rows, get the last used row (before/after removing the empties)?
</div>


I'm not sure what you mean by counting rows. What do you want to count, the empty rows, the non-empty rows, get the last used row (before/after removing the empties)?

<div>
<div class="content wysiwyg-content">
Hi, im looking for a string of code which will count till the last row and then delete any blank rows<br />
<br />
I dont want the code to loop through each row as i have 180k rows<br />
<br />
Many thanks
</div>
</div>


Hi, im looking for a string of code which will count till the last row and then delete any blank rows

I dont want the code to loop through each row as i have 180k rows

Many thanks

Count rows and delete blank rows

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