I know there is a line of code that allows one to find the last row of a worksheet, and then work it's way to a row with a populated cell.
Let' say, I would to start of the bottom, but in my case the bottom is row 1000 and continue searchin upward (rows, 999, 998,.....) until reaching row 5...