<div>
If you sort on column Q the blanks will be at the top or bottom. Then just select and delete as normal.<br />
<br />
If you need to keep the data in the order that it is, you can add a sequential id in another column and then resort on this after the blanks deleted.<br />
<br />
Alternatively, you can filter on column Q for blanks and when deleting it will only delete the visible rows.
</div>


<div>
<div class="content wysiwyg-content">
I have a set of data on Sheet1 from columns A:AA. &nbsp;I need a way to perform the following. &nbsp;Check each row in Column Q, if it is blank then delete that entire row of data. &nbsp;I need to perform this all the way down to the last row of data.
</div>
</div>


I have a set of data on Sheet1 from columns A:AA.  I need a way to perform the following.  Check each row in Column Q, if it is blank then delete that entire row of data.  I need to perform this all the way down to the last row of data.

VBA Script for Excel to delete 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.