Finding Last Row
 

In a worksheet that someone can enter as many rows of
data as they want, is there an easy way of finding the
last row that data has been entered to for looping
purposes? thanks!

Finding Last Row
 

Dim rng as Range, cell as Range
set rng = Range(cells(1,1),Cells(rows.count,1).End(xlup))
for each cell in rng

Next

--
Regards,
Tom Ogilvy


"Clint" wrote in message
...
In a worksheet that someone can enter as many rows of
data as they want, is there an easy way of finding the
last row that data has been entered to for looping
purposes? thanks!