How many times have you encountered the “Numbers Stored as text” error in your data sets? It interferes with your LOOKUP and MATCH […]

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