> From: frneto@br.homeshopping.com.br
> Subject: Excel used cells
> Date: Tue, 17 Feb 1998 18:25:56 -0600
> Newsgroups: microsoft.public.excel.programming
>  
>  
> How to know the last row used in worksheet?


LastRow = Cells.SpecialCells(xlLastCell).Row

This includes cells with individual formats or protection information. In 
this case, to get the last row containing data use:

RealLastRow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row

HTH,

John Green - Excel MVP
Sydney
Australia