A bug found because of using End(xlDown) Please stop using Range("A1"). ...
Finds last occurrence of a match in a column Finds the row of last time an ...
50 chars max.