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 of us use VBA to automate tasks of varying complexity – some macros are executed in a flash, but others take hours to run. While there are users who are happy with just a Msgbox “This thingContinue reading “Progress Bar for all your excel Applications”

Initialize Local Range Names in VBA Quicker


I always use locally named range in all my spreadsheets, in fact I wrote a post about it earlier. I extend my love for named ranges even while writing VBA code for spreadsheet applications. Using a pure Offset function based code, or a Cell Reference based code, in my opinion, is not the best way to go. HavingContinue reading “Initialize Local Range Names in VBA Quicker”

Excel Report Generator – Fill Reports with Records, Print and Save Automatically


Many small-scale businesses do not use database management systems to generate reports. Most of them stick to spreadsheet packages. Unfortunately Spreadsheet softwares are not equipped with  advanced query and report generating features. However, some Excel users struggle with Reports that they update, save and print manually. It is a very tedious job, but VBA canContinue reading “Excel Report Generator – Fill Reports with Records, Print and Save Automatically”

Range Navigator – Smarter Navigation for Excel


My previous Excel Navigation add-in fetched a few fans; I got a lot of positive feedback on LinkedIn. I designed it to help people working on enormous spreadsheets. I then realized that big workbooks usually host many sheets. I received a few requests to add worksheet selection functionality into the form. Nothing makes me happier than toContinue reading “Range Navigator – Smarter Navigation for Excel”