Delete Worksheet Using Excel VBA | Excel VBA Automation

Delete Worksheet
  • Save

Introduction/Problem Statement/Business Need:

This article is to Delete Worksheet in a workbook using Excel VBA code.

In many cases, the user wants to delete the worksheet without manual intervention.


Delete Worksheet:

This code will delete a worksheet by its name.

Delete Worksheet
  • Save

This code will delete a worksheet by Index number.

delete worksheet by Index number
  • Save

This code will delete the last worksheet in the workbook.

delete the last woksheet
  • Save

Delete Worksheet Without Deleting Prompt:

Deleting prompt has been shown in below screenshot :

Delete Worksheet Without Deleting Prompt
  • Save

This code will delete sheets without deleting prompt:

delete sheets without deleting prompt
  • Save

This code will delete the “Data” sheet if it exists:

code will delete
  • Save


If you want to delete worksheet in a workbook then you may use any of the above code instead of manually doing it. KDataScience would prefer you to use code to delete the sheet without “Deleting” Prompt.

Don't miss out!
Subscribe To Newsletter

Get the latest Excel, VBA, Automation, Tips & Tricks, delivered straight to your inbox.

Invalid email address
Give it a try. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

Copy link
Powered by Social Snap