A slightly "improved" version of my VBA Code Indenter is available.
This version starts indenting after Sub and Function names. The reason I decided to do this is because it seems to be the standard with other folk’s code I have seen posted online. Who a…
There are 2 VBA code indenters that I know of, and unfortunately, I am not able to install either of them where I need them most to due to admin rights. With "complex" code, indenting can help a lot by making code easier to read so I decided to make my ow…
When I saw Paste Special in Excel 2010, I thought "Cool!". I was a bit dubious about some of the choices and the icons that represent them, but that was okay because nobody ever thinks the same way.
However, I had 2 problems. The first is I only have 2…
Adding a row to the bottom of an AutoFilter is something we do often enough but doing it without code requires more clicks than I would like – copy an existing row, select the row below where the existing bottom row is, then opening up Paste Special. We p…
In Excel 2010, one of the handy features that was added is a filter search box for Autofilters.
It’s great that the filter actually changes as you type. But I don’t always work with 2010, so I decided to make something close. I wanted something whe…
