Tag Archives: excel last row

How To Find the Last Row That Contain Data in Excel?

UPDATE June 13, 2008: Another alternative way to find the last row with data : Function LastRow() As Long Dim ix As Long ix = ActiveSheet.UsedRange.Row – 1 + ActiveSheet.UsedRange.Rows.Count LastRow = ix End Function I did a simple test, … Continue reading

Posted in Excel VBA Function | Tagged , , , , , , , , , , , , , , , | 31 Comments