Showing tag results for Microsoft Excel

Hey, Scripting Guy! I need a script that can read all the values in a spreadsheet and then change the background colors of the cells in that spreadsheet based on a range of values. For example, if the value is less than 20 the cell gets colored one color; if the cell is between 20 and 40 it gets colored another color; and so on. How do I do that?-...

Hey, Scripting Guy! I’m trying to import a spreadsheet into an Access database. The problem is that the spreadsheet has multiple worksheets. I can import the first worksheet without any problem, but I can’t figure out how to import all the other worksheets in the file. How can I import multiple worksheets into an Access database?-- EA ...

Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet?-- SK Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started planning the 2008 Winter Scripting Games (February 15th through March 3rd, right here in the ...

Hey, Scripting Guy! How can I cut a row from an Office Excel spreadsheet and paste it into the first unused row in another Excel spreadsheet?-- NC Hey, NC. We apologize if today’s column feels a little damp; as it turns out, those of us in the Seattle area are experiencing another one of the Puget Sound’s … delightful … shifts in the weather. Sa...

Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10?-- MJdR 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 California was a fake. Instead of having real re...