Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Copy Data From One Spreadsheet to Another?

August 22, 2007 Aug 22, 2007 08/22/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy data from one Excel spreadsheet to another Excel spreadsheet?-- AC (image) (image) (image) Hey, AC. You know, we’re going to let you in on a little secret here: the Scripting Guy who writes this column is a tad bit tired this morning. That’s because he arrived home late last night (well after ...

How Can I Replace Text in an Excel Spreadsheet?

August 16, 2007 Aug 16, 2007 08/16/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I replace text in an Excel spreadsheet?-- PD (image) (image) (image) Hey, PD. We’ll talk about replacing text in an Excel spreadsheet in just a moment. But first, let’s address the question that’s on everyone’s mind: what is the Scripting Guy who writes this column going to do today as his ...

How Can I Delete Specified Rows in an Excel Spreadsheet?

June 23, 2007 Jun 23, 2007 06/23/07
ScriptingGuy1
(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?

June 21, 2007 Jun 21, 2007 06/21/07
ScriptingGuy1
(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, ...