Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

How Can I Delete Specified Rows in an Excel Spreadsheet?

(image) Hey, Scripting Guy! How can I delete a row in an Excel spreadsheet if there is a specific value in column A of that row?-- OI (image) (image) (image) Hey, OI. Before we get rolling on today’s column, have we mentioned that time is beginning to run out on the Scripting Guys TechEd Challenge? We have? Oh. Well, we’re going to ...

How Can I Color Every Other Row in an Excel Spreadsheet?

(image) Hey, Scripting Guy! When I create a new Excel spreadsheet, I’d like to color every other row in that spreadsheet. How can I do that?-- TM (image) (image) (image) Hey, TM. We know a lot of you have been wondering, “Gee, what’s the matter with the Scripting Guy who writes that column? He just doesn’t seem like his usual, ...

How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?-- GL (image) (image) (image) Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking their...

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

(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...