<div>
Hello RFGNaper,<br />
<br />
if there is a continuous column like A or B you can get do it like<br />
<br />
assuming you already have your variables declared<br />
<br />
'this will give you the last row<br />
intRowCount = mySheet.[A1].End(xlDown).R<wbr />ow<br />
'this will clear all cells in the sheet except the first<br />
mySheet.Range(&quot;A2:Z&quot; &amp;&nbsp;intRowCount).Clear ' Z is you last column<br />
<br />
hope this helps a bit<br />
bruintje
</div>


Hello RFGNaper,

if there is a continuous column like A or B you can get do it like

assuming you already have your variables declared

'this will give you the last row
intRowCount = mySheet.[A1].End(xlDown).Row
'this will clear all cells in the sheet except the first
mySheet.Range("A2:Z" & intRowCount).Clear ' Z is you last column

hope this helps a bit
bruintje

<div>
<div class="content wysiwyg-content">
I have added a &quot;clear&quot; button to an excel sheet and I need the VB.Net code to clear the contents of the entire sheet, minus the column headings (1 line). &nbsp;The ending cell will constantly be changing each time the user uses the &quot;clear&quot; button.
</div>
</div>


I have added a "clear" button to an excel sheet and I need the VB.Net code to clear the contents of the entire sheet, minus the column headings (1 line).  The ending cell will constantly be changing each time the user uses the "clear" button.

Clear an Excel sheet using VB.Net

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.