lastrow=cells(rows.count,"e").end(xlup).row
cells(lr,"d")=1

--
Don Guillett
SalesAid Software

"Chas" wrote in message
...
Writing a VBA in Excel, how do I know if I am at the last row of data?
The column I am processing may have empty cells. But an adjourning cell
will always have something until the end of rows is reached. Is there an
equivalent EOF or do I examine the adjourning column as I process?