New to Excel VBA, trying to find out:

1. How to search (or find) from the bottom of a column upwards.

2. Once the search result is found I need to delete all the column data from
that result up to row 2 of the column.

Can anyone help? I've been messing around with this for a few weeks now and
cannot figure it out - sorry!