Dim LastRowNumber as long
lastrownumber = lastrow.row





wrote:

Thanks Chip.

Where almost there...

How do I get the integer value of the last row from the Range LastRow ?

Dim LastRow As Range
Set LastRow = Cells(Rows.Count, "A").End(xlUp)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
oups.com...
I need to loop through all the rows on a worksheet ...

There are patches where there are groups of existing but unused
rows
...

How do I get the last used row in VBA?

Thanks.


--

Dave Peterson