You are adding data on a consistent basis to your spreadsheet, and you need to have a macro that references the last row that was just added to your Excel spreadsheet data range or table. This article and associated video will show you how to do just that. Fig 1 So similar to "Fig 1" above you would like to reference row 14 of the table and possibly iterate over each … [Read more...] about How To Find The Last Row In an Excel VBA Range
All Articles
what does excel dsum do
Dsum queries your Excel data and provides answers based on the criteria that you provide to the dsum function. More to the point in order to use dsum you have to decide to layout your spreadsheet using best practice spreadsheet design principles. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are … [Read more...] about what does excel dsum do
what does vlookup do
This article and associated youtube video will explain what vlookup does and the best way to organise your spreadsheet data to the get most out of vlookup and how to use it to join two datasets together. Vlookup allows you to get extra information from another data range by using a unique identifer that populates the first column of the data range that your are looking … [Read more...] about what does vlookup do
How To Resize A Named Range In Excel VBA
To resize a named range in Excel VBA it's best to get an object reference to the range and then use the Excel VBA resize method to resize the range. With the resized range object you then set it's name property to the range name that you want resized. Excel will behind the scenes delete the old range name and replace it with the one you have just created. The spreadsheet … [Read more...] about How To Resize A Named Range In Excel VBA
How To Copy A Range Of Cells In Excel Using VBA
There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA