Find the last item and select it

[Djblois]

I know how to find the next item in a workbook but how can I find the last one. ex:

test
test
test
test
test
test
test
report

I would like to find the last test before report with the find command. Is this possible?

Daniel