Mike Wolfe

A deep dive into the Empty keyword in VBA: why it exists, how to check for it, when it makes sense to check for it, and--most importantly--how NOT to check for it.

Wondering what the IsMissing() function is all about in VBA? We'll explore that plus all the ins and outs of the VBA keyword that isn't: Missing.

Let's explore the many ways to check for, handle, and store Null values. Spoiler alert: the best way to do it varies between VBA and SQL.

An in-depth look at the Nothing keyword in VBA: when you need it; when you don't; and one technique to avoid it altogether.

This one's for the nihilists. We explore the many ways to express the concept of nothingness in VBA.