Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Determine the Last Row in an Excel Spreadsheet?

February 15, 2006 Feb 15, 2006 02/15/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine the last row in an Excel spreadsheet? I can’t append data to the file unless I know which row to start with.-- TGW(image) (image) (image) Hey, TGW. You know, this is the kind of thing that separates the Scripting Guys from the rest of the world. Most people would do the same thing you’re ...

How Can I Change the Footer in an Excel Spreadsheet?

December 21, 2005 Dec 21, 2005 12/21/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet?-- JA(image) (image) (image) Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script that ...

How Can I Sort Worksheets in a Workbook?

November 22, 2005 Nov 22, 2005 11/22/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I sort worksheets in a workbook?-- FS(image) (image) (image) Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process is a tiny bit ...