# Scripting Blog [archived]

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

## Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

(image) Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10?-- MJdR(image) (image) (image) Hey, MJdR. You know, just a few days ago word leaked that a Federal Emergency Management Agency (FEMA) press conference held to discuss the US governmentâ€™s response to the recent spate of wildfires in ...
Comments are closed.0 0

## Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?

(image) Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isnâ€™t supposed to be a number, itâ€™s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed, convert those dates back to numbers?-- TC(image) (image) (image) Hey, TC. Yes, as a matter ...
Comments are closed.0 0

## How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

(image) Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files?-- BR(image) (image) (image) Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch as the Washington Huskies dismantled Boise State 24-10, ...
Comments are closed.0 0

## How Can I Add a Background Picture to an Excel Worksheet?

(image) Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA(image) (image) (image) Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt â€¦ right before he eats his daily doughnut. (But donâ€™t worry: itâ€™s a medically-...
Comments are closed.0 0

## How Can I Copy Selected Columns From a CSV File to an Excel File?

(image) Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file?-- MdP (image) (image) (image) Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum. Some of you might be concerned that ...
Comments are closed.0 0