VBA: How to Write Your Own Function

So last week, I learned that VBA buttons are supremely helpful. For moving data between workbooks or breaking down information from a KML file, these are ideal. Especially the KML file importer because it’s basically populating a full on spreadsheet. But if you want to have a function run very specific math or customized scraping […]

Read More VBA: How to Write Your Own Function

VBA: What? Just… What?

I know shockingly little about Excel. And that is somewhat unsettling because most of my jobs, which I depend on for food and rent and coffee, require a fuck-ton* of spreadsheets. In the interest of keeping myself rolling in coffee grounds, I’ve made myself sludge through VBA tutorials this weekend and put together a few […]

Read More VBA: What? Just… What?