I have an attendance sheet that has point values in column E. What I need is so code will start at the bottom of sheet (row 1000) and look up a row at a time until it finds a row in column E that is > zero. The reason it needs to start at row 1000 is that the sheet is sorted newest occurance to oldest and I am looking for the oldest occurence that has a point value. Not all occurences have a point value. If they don't they will have a zero in column E.