***Resolved***Last row in excel

is there anyway of finding the number of the last row in excel without looping through first?

Unless you are trying to find the very last row (which is probably empty) thois should work:

VB Code:

MaxRowNumber = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row

perfect thanx

No problem

please reedit the starting thread an put an [RESOLVED] in the topic!

Soory you already did that :p