10/25/2014

Excel: Find the last row of data in a range

LastRow = Cells.SpecialCells(xlCellTypeLastCell).Row
or
LastRow = AWs.UsedRange.Rows.Count

No comments:

Post a Comment