Excel’s Application object’s WorksheetFunction property is a container for Microsoft Excel worksheet function. This property returns a WorksheetFunction object that allows […]
Archive for ‘Tips and Tricks’
Fit Worksheet to Window in Excel
Have you ever felt Excel needed a Fit-Document-to-Window-Width feature like the millions of PDF Readers out there? Wouldn’t it be […]
How To Quickly Get A List All DAX Formulas From Your Excel 2010 PowerPivot Data Model
In this post, I describe a quick way to list all the DAX formulas in your PowerPivot for Excel 2010 Data model.
When do I use the Sheets Collection in Excel VBA?
There are two collections in Excel-VBA that lets the user access sheets in a workbook: the Sheets collection and the Worksheets collection. […]
How to deal with the Numbers Stored As Text Error in Excel?
How many times have you encountered the “Numbers Stored as text” error in your data sets? It interferes with your LOOKUP and MATCH […]
Prepare for the show: A framework for hiding rows and columns in your spreadsheet applications
Hiding a bunch of rows and columns in a sheet before showing it to your boss is inevitable. I insert […]
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 […]
Codename to the Rescue! – The best way to refer to a Worksheet whilst developing a Spreadsheet Application
Have you ever wondered why there are two properties called “Name” for a spreadsheet? Go ahead, open up the Visual […]
Excel Worksheet Functions and VBA Functions
Many excel users might not be aware of the subtle distinction between Excel Worksheet functions and VBA functions. Majority of […]
Introduction to Regular Expressions in VBA
Regular-Expressions (RegExp) is something I bumped into when my string manipulation requirements jumped to an advanced level. Before I started using this […]