"carlo" wrote in message ups.com...
On Nov 7, 11:13 am, Janis wrote:
EndRow = Cells(Rows.Count, 1).End(xlUp)

I need the last used row count. This statement seems to count the last row
but not the used range. How do I find the last used row?

thanks,

EndRow = Cells(65536,1).End(xlup).row

The same but one that would work in all versions of Excel

Sub GotoBottomOfCurrentColumn()
'based on a posting by Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

Additional similar macros and toolbar buttons to go with them in
http://www.mvps.org/dmcritchie/excel/toolbars.htm


--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm