This is my first and possibly only foray into the madness that is constructing a YouTube video. I’ve been watching the Vlog Brothers for years, and I’ve never appreciated the effort that goes into it. Pick a topic, write a script, animate the graphics, trim clips, find background music, and also, cut around all your […]Read More YouTube: Tips for Making a How-To Video
Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.Read More VBA: How to Use VLookUp in a Macro
A couple months ago, I did the exact opposite of this. I called it the ListToRange() Function. It’s weirdly helpful at work because I have to go back and forth between having numbers listed out and then having them clustered for other things.Read More VBA: How to Get A List From a Range of Numbers
“Range object” is an unnecessarily intimidating term for a collection of cells within your workbook. Say you need to run some complicated math or formatting over the same cells over and over throughout a long script. You could call on the column number and row every damn time, but who wants to do all that […]Read More VBA: What is a Range Object?
So I’ve finally reached that point where I’m writing Macros well enough to accomplish simple tasks, but the results are just not pretty to look at. One of my macros returns a list of numbers associated with some data in a worksheet that looks like this: , 1, 2, 3, 4, 5, 7, 10, 11, […]Read More VBA: How to get a Range of Numbers from a List
Imagine you have a combination lock with 4 digits. If you wack your head against a car hood by accident and forget the combination, this means you have a problem with 255 wrong answers and 1 right one. If you had a few days to spare, you could try all of them. The marvelous thing […]Read More VBA: How to Crack the Caesar Shift with Brute Force
You know what I’ve wanted all my life? A way to condense columns into comma separated lists. I’ve been in multiple jobs where this would’ve been handy because it’d be so much easier to see all the things in a few rows.Read More VBA: How to Condense Two Columns into a List