<div>
try this:<br />
<br />

<pre><code id="code-20-43013748-1">Sub sbVBS_To_Delete_EntireColumn(columnName As String)
    Columns(columnName).EntireColumn.Delete
End Sub</code></pre>
<br />
to implement:<br />
<br />

<pre><code id="code-20-43013748-2">call sbVBS_To_Delete_EntireColumn(&quot;C&quot;)</code></pre>
</div>


try this:



Sub sbVBS_To_Delete_EntireColumn(columnName As String)
    Columns(columnName).EntireColumn.Delete
End Sub


to implement:



call sbVBS_To_Delete_EntireColumn("C")

application programmer

Mohammad Alsolaiman

<div>
Thanks Ryan<br />
That's much better than column number, but I would prefer if there is any way to delete it using the name appear in the first row, which in my case is &quot;&nbsp;DateOfBirth&quot; . is it possible to do so?
</div>


Thanks Ryan
That's much better than column number, but I would prefer if there is any way to delete it using the name appear in the first row, which in my case is " DateOfBirth" . is it possible to do so?

<div>
<div class="content wysiwyg-content">
Hello,<br />
I need to delete Entire column in Excel sheet using column name.<br />
In my example I need to delete the 3rd column with the name &quot;DateOfBirth&quot;, instead of using column number.<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/01_w04/1441387/delete-column-by-name.PNG" target="_blank" title="delete column by its name (9 KB)"><img alt="delete column by its name" class="file-block lazyload" style="max-width: 619px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w04/1441387/delete-column-by-name.PNG" /></a>The code I'm using right now is:<br />

<pre><code id="code-10-29170036-1">Sub sbVBS_To_Delete_EntireColumn ()
    Columns(1).EntireColumn.Delete
End Sub</code></pre>
</div>
</div>


delete-column-by-name.PNG

Hello,
I need to delete Entire column in Excel sheet using column name.
In my example I need to delete the 3rd column with the name "DateOfBirth", instead of using column number.

The code I'm using right now is:
(CODE)

Delete Entire Column by column name - using VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.