Stumbling Around
Programming the Things


Written by Jay Killeen


A Simple Worksheet Parameter Pattern for Power Query

Published on February 26, 2020 at 04:17AM

How cool would it be to call a value from an Excel Worksheet from within a Power Query using a simple variable definition?

Cross Join in Power Query to Combine Two Tables with Every Combination

Published on September 13, 2019 at 04:06AM

When you want 'red,green' and '1,2' to become 'red1,red2,green1,green2' use a cross join!!

Debugging Postgresl and Rails PG::ConnectionBad: could not connect to server: Connection refused

Published on December 20, 2018 at 12:01PM

WHY??? It's your home! Go to your home!!

Things I Always Get Wrong When Programming

Published on December 18, 2018 at 11:03PM

Maybe if I write down the things I continuously do wrong then it will help me to fix them for next time XD

Rails new with Webpacker, Vue and Postgres

Published on December 12, 2018 at 04:14AM

I always forget my last process for starting a greenfield rails app

An Elegant Way to Clear the Excel VBA Immediate Window When Debugging

Published on October 17, 2018 at 04:45AM

Your Immediate Window is so jammed with debug.print that you just want to clean slate it... quickly... and elegantly... like a gazelle.

5 Level Cascading Validation Lists in Excel using VBA

Published on October 11, 2018 at 12:18PM

You need validation lists to change based on selections... like a cascading validation list

Edit Data Validation Lists in Excel using Arrow Keys

Published on October 11, 2018 at 06:16AM

You are trying to edit a Data Validation List and when you click the arrow keys things turn crazy and annoy you sooooo bad!

[SOLVED] Fix Duplicate Conditional Formatting Rules in Excel 2016

Published on September 18, 2018 at 04:48AM

You have conditional formatting rules in Excel 2016 and all of a sudden they are duplicated all over the place and super messy. This fixes it.

Building Your Own (And Better) Autosave Feature for Excel

Published on June 07, 2018 at 11:13PM

Because the current Excel Autosave is just so bad XD