| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Delete" method of a worksheet object
Hi,
I'd like to delete a worksheet silently, but Excel asks for a confirmation, because the sheet is possibly not empty. I tried to clear or delete its usedrange beforehand, but it doesn't work neither (still asks for confirmation). My question: How to bypass this automatic request. By the way, I don't understand that in the VB editor, "delete", the "d" is written in lowercase. Thanks in advance. -- Jean-Pierre Bidon Interstat 91 rue de Rennes 75006 Paris Tél: 01 45 49 19 17 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interactive Chart/ "Method Cells of object '_global' failed" | Excel Programming | |||
| Excel-VBA: "1004 - Method 'Range' of object '_Global' failed" | Excel Programming | |||
| "GoalSeek method of Range object failed" error message | Excel Programming | |||
| METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file | Excel Programming | |||
| "Select Column method or property not available because some/all of object doesn't refer to table" | Excel Programming | |||
Threaded Mode
