Last Row

How do i find the last row (or cell) that contains data?

I assume that your talking about Excel so use this (one of a few ways).

VB Code:

MsgBox ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row