<div>
<div class="content wysiwyg-content">
I have two worksheets called:<br />
CW data<br />
Raw SMMT Data<br />
<br />
I would like to clear the columns A to N<br />
<br />
I know the number of columns that stays fixed how do I clear downwards to the last populated row?<br />
<br />
would prefer not to have to go to 65536 as thats wasting processing time.<br />
<br />
regards in advance
</div>
</div>


I have two worksheets called:
CW data
Raw SMMT Data

I would like to clear the columns A to N

I know the number of columns that stays fixed how do I clear downwards to the last populated row?

would prefer not to have to go to 65536 as thats wasting processing time.

regards in advance

Clear range of cells in one or more excel worksheets

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