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 “includes” new data you add to your spreadsheets, it automatically drags down formulas for you, it automatically formats the tables for you. In addition to that, you can use structured references that make your formulasContinue reading “Magically Format Tables in Excel using VBA”

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”

Local trumps Global – Local Named Ranges make the spreadsheet more tractable


Creating user friendly spreadsheets is not just a professional courtesy anymore. We have the obligation to help users decipher the spreadsheet we so hastily put together. Spending a little extra time setting up well designed spreadsheets help a firm reduce future costs by reducing the time spent on testing and scrutinizing the sheet. improving theContinue reading “Local trumps Global – Local Named Ranges make the spreadsheet more tractable”