Get the Actual Used Range in a Spreadsheet


In one of my posts, I wrote about the UsedRange property of the Worksheet object. I use it in almost all of my spreadsheet applications. Excel keeps track of the last cell you used during your current session, and uses it to determine the used range of a sheet. The last cell is the one you get to, when you pressContinue reading “Get the Actual Used Range in a Spreadsheet”

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”

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 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.