For Each rCell Query

Hi,

I have a piece of code which looks like this

For Each rCell In Range("A2:AF300").Rows

Is it possible to change it so that the start point is A2 but the end point is the last row containing data? The last column will still be AF but the row will be variable.

Thanks

Tim.

Assuming column A always has data for each row:

For Each rCell In Range("A2:AF" & cells(rows.count, "A").end(xlup).row).Rows

Hello,

find the last row with code like

dim rCell as range
dim lrow as long
lrow = cells(rows.count, "A").end(xlup).row
for each rCell in Range("A2:AF" & lrow)
   ' do something
next rCell

cheers,