Scripting Blog [archived]

How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

May 1, 2007 May 1, 2007 05/1/07

ScriptingGuy1

(image) Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN(image) (image) (image) Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend. Ah, but...