This code works fine, I just wanted to put this out there to see what other
people use. Is there a faster more efficient way to return the row number of
the first row that does not contain "Archive" or "Ready" in Col.M?


' find first row without Archive or Ready
lngFirstRow = 3
Do While .Cells(lngFirstRow, "M") = "Archive" Or .Cells(lngFirstRow,
"M") = "Ready"
lngFirstRow = lngFirstRow + 1
Loop
--
Cheers,
Ryan