<div>
An eloquent and articulate answer. &nbsp;I had forgotten that you had to use .Range to delete cells, even if single ones.<br />
<br />
Thanks.
</div>


An eloquent and articulate answer.  I had forgotten that you had to use .Range to delete cells, even if single ones.

Thanks.

<div>
No worries. Thanks for the grade.<br />
<br />
Rob.
</div>


<div>
<div class="content wysiwyg-content">
Is there a way to delete a SINGLE CELL in an Excel worksheet using VBS? &nbsp;I want it to delete the cells and move whatever data is to the right of it into that cell.<br />
<br />
I've searched around, but it appears you can only delete ROWs. &nbsp;If that's the case, I'll have to draft the logic that moves the cell contents to the left.<br />
<br />
Thanks for whatever help you can be.
</div>
</div>


Is there a way to delete a SINGLE CELL in an Excel worksheet using VBS?  I want it to delete the cells and move whatever data is to the right of it into that cell.

I've searched around, but it appears you can only delete ROWs.  If that's the case, I'll have to draft the logic that moves the cell contents to the left.

Thanks for whatever help you can be.

Delete Single Cell - VBS

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.