Check out exceltips.nl - Excel & VBA

One common method LastRow = Cells.SpecialCells(xlCellTypeLastCell).Row which is not very exact, because Excel doesn’t keep track of the last cell in a very adequate form. Another method to find the last used row in a particular column is: LastRowColA ...

www.exceltips.nl