Initialize Local Range Names in VBA Quicker

February 9, 2014Posted inApplications18 Comments
VBA Range Names Declare Assistant

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. Having named ranges in worksheets, and updating them to include more data before processing is the best way to go.

Codename to the Rescue! – The best way to refer to a Worksheet whilst developing a Spreadsheet Application

January 10, 2014Posted inTips and Tricks7 Comments

Have you ever wondered why there are two properties called “Name” for a spreadsheet? Go ahead, open up the Visual Basics Editor; go to the Project Explorer Window, and select a sheet from the ‘Microsoft Excel Objects’ Node. You will notice that there is a ‘(Name)’ and a ‘Name’ property.