How many times have you encountered the “Numbers Stored as text” error in your data sets? It interferes with your LOOKUP and MATCH […]
Magically Select All The Used Areas In A Sheet using VBA
I recently published a post about automatically formatting a table in Excel using VBA. That got me thinking, how awesome it […]
Magically Format Tables in Excel using VBA
Excel Tables make analyzing data, a breeze. It surprises me that it is not used as often as it should. It automatically […]
Get the Actual Used Range in a Spreadsheet
In one of my posts, I wrote about the UsedRange property of the Worksheet object. I use it in almost all […]
To Err is Excel, Handle your Errors with grace
Error handling is an important aspect of programming in VBA, especially if you are writing macros for other users. Unfortunately, many […]
Snakes in Excel, Lets Play!
The biggest downside to working in massive corporate offices is the locked down computer systems. There is no internet access, no games, […]
Progress Bar for all your excel Applications
Excel is versatile by itself and VBA makes it even better by allowing us to do our own thing. Most […]
Mix And Match – Get all possible permutations of an unlimited number of lists in Excel
This post is a little fun, not much of a Struggle I guess. In excel, we use permutations more often […]
Concatenate Unique Cells, with Text Formatting
A fellow struggler requested me to help him with a slightly beefed up Range Concatenate function. He needed to combine a […]
