Unable to delete a worksheet in a workbook.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I try to delete a worksheet in a workbook using .Delete() method of the
worksheet object. When I run the program nothing happens.

Can any one point to me how to delete a worksheet in a workbook using Excel
object?

Please see below for my working environment.

Platform:
..NET 1.1 program references MS Excel 11 library.
MS Office 2003.

Thanks
D. Santhosh
 
Hi Dales,

Below is my code to delete "Sheet1" worksheet in my workbook.

With DirectCast(ThisWorkBook.Sheets("Sheet1"), Excel.Worksheet)
.Select()
.Delete()
End With

Thanks
D. Santhosh
 
Hi Rowan,

I tried "ThisWorkbook.Sheets("Sheet1").Delete". It does not seem to work.

Thanks,

D. Santhosh
 
In what way does it not work? Are you getting an error message? Is the
sheet still there after you run the code? Etc etc?

Regards
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign a worksheet in VBA 3
How to reference a cell from anther workbook without opening it 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel crashes and restarts when accessing newly created worksheet 2
Run macro on all files in a specific folder 3
NEW Worksheets - Limitation on Creating and Deleting (-fes) 2
How to append data from different sheet and different workbook? 2
Import multiple workbooks to current workbook in specified row number 0

Back
Top