How many times have you encountered the “Numbers Stored as text” error in your data sets? It interferes with your LOOKUP and MATCH […]
Author Archives
Ejaz
I specialized in actuarial science in my masters’ program and I am determined to become a qualified actuary. I invest extra time and effort into creating intuitive spreadsheet applications that improve productivity at the workplace. I also enjoy spending my leisure time creating digital art; I publish my designs on my art in this blog named Designecdotes. Most of the people who have dramatically influenced my life were enthusiastic academicians. I believe that the greatest gift in life is having a nurturing mentor, and I would like to be that for someone. I owe it to my future mentees to be the best at what I do, and I consciously direct my endeavors at gathering what I consider essential traits of a seasoned mentor.
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 […]
