Initialize Local Range Names in VBA Quicker

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.

Continue reading “Initialize Local Range Names in VBA Quicker”

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

Name Property

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.

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