Find the LastRow

Hi all,

I'm trying to find the last row with data and declare it so I can just use it after to refer to Cells. I know the last row with data is 18 but it varies sometimes.

I tried something like this :

dim lastrow as long,i as integer

lastRow = cells(Rows.count.end(xlup),1)

for i = 5 to 57
cells(lastrow,i)...
next i