{"id":12056,"date":"2011-10-11T10:09:52","date_gmt":"2011-10-11T10:09:52","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=18"},"modified":"2017-09-20T06:48:07","modified_gmt":"2017-09-20T06:48:07","slug":"how-to-delete-a-selected-sheet","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/","title":{"rendered":"How to delete sheet using Excel Macro"},"content":{"rendered":"

Dear Friends,
\nWhile automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do.
\nIn this article, I am going to teach you all about deleting the Sheets from a workbook<\/strong> through Excel VBA.
\nThere are many scenarios – based on how and which sheet do you want to delete it from Workbook. I will explain you each one of them by providing an Example VBA Code which you can directly use them in your VBA programs.<\/p>\n

Topics covered in this Article<\/h1>\n

All possible cases of deleting a Sheet from Workbook using Excel VBA, are covered here.<\/p>\n

\n
\n

<\/i>   VBA To delete First sheet of the workbook irrespective of its name<\/a><\/h2>\n

<\/i>   VBA to delete the last sheet of the workbook<\/a><\/h2>\n

<\/i>   VBA to delete the ActiveSheet<\/a><\/h2>\n

<\/i>   VBA to delete a sheet with a specific name in a Workbook<\/a><\/h2>\n

<\/i>   VBA to Check if a Specific Sheet exists in a Workbook<\/a><\/h2>\n

<\/i>   VBA to delete multiple sheets from a Workbook<\/a><\/h2>\n

<\/i>   VBA to delete Sheet without Warning Message<\/a><\/h2>\n<\/div>\n<\/div>\n

<\/a><\/p>\n

Excel VBA to Delete first Sheet of Workbook<\/h1>\n

Using simple Worksheets(1).Delete<\/code> statement will be able to delete the first Worksheet from your workbook. Refer the below function where this statement is used to delete the First Worksheet.<\/p>\n

\r\nSub DeleteFirstSheet()\r\n\tOn Error GoTo err\r\n' Disable excel alerts sent while deleting a sheet\r\n\tApplication.DisplayAlerts = False\r\n\tWorksheets(1).Delete\r\n\tMsgBox (\"First is successfully deleted\")\r\n\terr:\r\n\tApplication.DisplayAlerts = True\r\nEnd Sub\r\n<\/code><\/pre>\n

Note:<\/strong> Above function will always delete the first Worksheet from the workbook.
\nIf there is only one sheet in the workbook, then it will do nothing because last one sheet can not be deleted from any workbook. At least one Sheet should remain in it.<\/em><\/p>\n

<\/a><\/p>\n

Excel VBA to Delete Last Sheet of Workbook<\/h1>\n

Using simple Worksheets(1).Delete<\/code> statement will be able to delete the first Worksheet from your workbook. Refer the below function where this statement is used to delete the First Worksheet.<\/p>\n

\r\nSub DeleteFirstSheet()\r\n    On Error GoTo err\r\n' Disable excel alerts sent while deleting a sheet\r\n    Application.DisplayAlerts = False\r\n    Worksheets(Worksheets.Count).Delete\r\n    MsgBox (\"First is successfully deleted\")\r\nerr:\r\n    Application.DisplayAlerts = True\r\nEnd Sub\r\n<\/code><\/pre>\n

Note:<\/strong> Above function will always delete the last Worksheet from the workbook.
\nIf there is only one sheet in the workbook, then it will thrown an error and do nothing because last one sheet can not be deleted from any workbook. At least one Sheet should remain in it. Since in the above code, error is handled, hence you would not get any error.<\/em><\/p>\n

<\/a><\/p>\n

Excel VBA to Delete ActiveSheet from the Workbook<\/h1>\n

Using simple ActiveSheet.Delete<\/code> statement will be able to delete activesheet from your workbook. Refer the below function where this statement is used to delete the ActiveSheet.<\/p>\n

\r\nSub DeleteActiveSheet()\r\n\tOn Error GoTo err\r\n' Disable excel alerts sent while deleting a sheet\r\n\tApplication.DisplayAlerts = False\r\n\tActiveSheet.Delete\r\n\tMsgBox (\"ActiveSheet is successfully deleted\")\r\n\terr:\r\n\tApplication.DisplayAlerts = True\r\nEnd Sub\r\n<\/code><\/pre>\n

Note:<\/strong>This statement can be used for deleting any worksheet from the workbook using this workaround.
\n1. First activate the Worksheet which you want to delete
\n2. Then you can use this ActiveSheet.Delete statement<\/p>\n

<\/a><\/p>\n

VBA to delete sheet from Workbook – With specific name<\/h1>\n

You can delete a Sheet with a specific Display name by using Sheets(\"SheetNameToBeDeleted\").Delete <\/code>.
\nIf you simply use the above statement and just in case, sheet with such a specific display name is not available in that workbook, then it will throw an exception.
\nTo overcome this problem and throw a proper error message, you should first check if there is any Sheet with a given specific names exists. If, it exists then delete else you can throw an error message to the user.<\/p>\n

<\/a><\/p>\n

Excel VBA to check – if a given Sheet Exists in Workbook<\/h2>\n

In the below function, all you need to pass is the name of your WorkSheet, which you want to check. This function will return a Boolean – True or False as a result.<\/p>\n

\r\nFunction DoesSheetExists(SheetX) As Boolean\r\n    Dim SheetExists As Boolean\r\n    DoesSheetExists = False\r\n    For Each Sheet In Sheets\r\n        If UCase(Sheet.name) = UCase(SheetX) Then\r\n            DoesSheetExists = True\r\n            Exit Function\r\n        End If\r\n    Next Sheet\r\nEnd Function\r\n<\/code>\r\n<\/code><\/pre>\n

Now you can call this function to know whether Sheet X<\/em><\/strong> exists.
\nNow here is the actual code which will delete the specific Sheet where I have used the above function.<\/p>\n

\r\nSub DeleteSheetX()\r\n    On Error GoTo err\r\n    Application.DisplayAlerts = False\r\n\t'Call the DoesSheetExists function to check if sheets exists\r\n    If (DoesSheetExists(\"MySheetNameToDelete\") = True) Then\r\n        Worksheets(\"MySheetNameToDelete\").Delete\r\n        MsgBox (\"Selected Sheet is successfully deleted\")\r\n    Else\r\n        MsgBox (\"This Sheet does not exists\")\r\n    End If\r\nerr:\r\n    Application.DisplayAlerts = True\r\nEnd Sub\r\n<\/code><\/pre>\n

<\/a><\/p>\n

VBA to delete multiple Sheets at once<\/h1>\n

Sheets(Array(….)).Delete can be used to delete multiple sheets using once statement.
\nAll you need to use an Array keyword and provide the names of all the sheets you want to delete.
\nExample:<\/strong>
\nSheets(Array(\"Sheet1\",\"Sheet2\", \"Sheet3\")).Delete<\/code> = This will delete Sheet1, Sheet2 and Sheet3
\nSheets(Array(1,2,3)).Delete<\/code> = This will delete 1st, second and 3rd Sheets of the workbook.<\/p>\n

\r\nSub DeleteArrayOfSheets()\r\n    On Error GoTo err\r\n    Application.DisplayAlerts = False\r\n    Sheets(Array(\"Sheet1\", \"Sheet2\", \"Sheet3\")).Delete\r\nerr:\r\n    Application.DisplayAlerts = True\r\nEnd Sub\r\n<\/code><\/pre>\n

Note:<\/Strong> If any one of the Sheets which are mentioned in the array, does not exist then, it will throw an error and none of the sheets will be deleted – even if other sheets were existing.<\/p>\n

<\/a><\/p>\n

VBA to Delete Sheet without Warning Message<\/h1>\n

In excel, as soon as you try to delete a sheet, there is an inbuilt warning message which is popped up to confirm, if you really want to delete the sheet.
\nYou definately do not want to see that popup – every time when your VBA code is running and trying to delete a sheet. Once the popup appears, VBA execution will wait untill you manually confirm the popup.<\/p>\n

VBA to disable Delete confirmation Alert popup<\/h2>\n

It is simple to supress this confimation popup through Excel VBA. All you need to do is execute this statement Application.DisplayAlerts=False<\/code>.
\nThis is the reason, in all the above codes, if you notice, I have used this statement to suppress this delete confimation alert popup.
\nDo not forget to set it to true at the end of the function. If you fail to do so, then even when you try to delete a sheet manually, then also you would not receive this confirmation popup – which you may do not want.<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. In this article, I am going to teach you all about deleting the Sheets from a workbook through Excel VBA. There are many scenarios – based […]<\/p>\n","protected":false},"author":45,"featured_media":14289,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1675],"tags":[],"class_list":["post-12056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-for-beginners"],"yoast_head":"\nHow to delete sheet using Excel Macro - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to delete sheet using Excel Macro\" \/>\n<meta property=\"og:description\" content=\"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-11T10:09:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-20T06:48:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to delete sheet using Excel Macro\",\"datePublished\":\"2011-10-11T10:09:52+00:00\",\"dateModified\":\"2017-09-20T06:48:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\"},\"wordCount\":874,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\",\"name\":\"How to delete sheet using Excel Macro - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg\",\"datePublished\":\"2011-10-11T10:09:52+00:00\",\"dateModified\":\"2017-09-20T06:48:07+00:00\",\"description\":\"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg\",\"width\":800,\"height\":538,\"caption\":\"VBA to Delete Sheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to delete sheet using Excel Macro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to delete sheet using Excel Macro - Let's excel in Excel","description":"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/","og_locale":"en_US","og_type":"article","og_title":"How to delete sheet using Excel Macro","og_description":"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.","og_url":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-10-11T10:09:52+00:00","article_modified_time":"2017-09-20T06:48:07+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to delete sheet using Excel Macro","datePublished":"2011-10-11T10:09:52+00:00","dateModified":"2017-09-20T06:48:07+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/"},"wordCount":874,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg","articleSection":["Excel Macro","Excel Macro Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/","url":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/","name":"How to delete sheet using Excel Macro - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg","datePublished":"2011-10-11T10:09:52+00:00","dateModified":"2017-09-20T06:48:07+00:00","description":"Macro to delete sheet. VBA to delete multiple sheets. VBA to check if sheet exists. VBA to delete sheet without warning message. VBA to delete last sheet.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/delete-sheet-from-workbook-1.jpg","width":800,"height":538,"caption":"VBA to Delete Sheet"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-delete-a-selected-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"How to delete sheet using Excel Macro"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12056"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12056"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12056\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/14289"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}