Forum Discussion
Delete an EXCEL worksheet
I have a large EXCEL workbook with multiple worksheets. One of the sheets seems to be corrupt. If I select the corrupt sheet to delete my workbook is immediately closed before I can delete the corrup...
Ok, please try this solution:
- Open the workbook
- Press Alt+F11 to open the Visual Basic for Applications editor
- Put this command in the Immediate window: Thisworkbook.Worksheets("SheetName").Delete
- If the Immediate window isn't visible, press Ctrl+G to show it.
- Please replace the SheetName in the command with the real sheet name.
- Press Enter
Thank you so very much help me resolve my issue. Although I'm comfortable using the functionality EXCEL provides; I'm afraid I'm not tech savvy enough to understand how to correct an issue like the one I presented to you. Thanks again for your assistance.
jpw