> 
> Wolf  wrote in article
> > How do I get the location of last (blank) row of any list, including in
> > another worksheet?
> 
> If your rows are continuous, there are no blanks, and you don't pick a cell
> in the last row.  This should work fine.  It should also work if the cell
> is on another sheet.
> 
> Add this custom function:
> function LastRow(Cell)
>     LastRow = Cell.End(XlDown).row
> end function
> 
> then in any cell put the formula "= LastRow(Sheet1!A1)" if you want to see
> what the row number is for the last contiguous cell in column A of Sheet1.
> 
> Good luck.
>                         MGJ
Better (because it handles embedded blanks) is:
function LastRow(Cell)
     LastRow = cells(cells.rows.count,Cell.column).End(XlUp).row
 end function

The cells.rows.count gives 16384 or 65536 depending on which excel
version you have.