Delete values in one column based on values in a second column

I have a macro-enabled workbook in which I want to delete the vales from cells in one column based on values in another column. This example should make my meaning clearer:
DeleteValues.png
I want to delete values in the left column if the values in the right column are > 20 or < 0 so that, in this case, the last value in the left column would be 12.40 The data is such that the values in the two columns are always in ascending order.

One possible approach (which I have not been able to implement) might be to find the row number (N) of the first cell in the second column which meets the criteria (> 20 or <0) and then set the range to be deleted to be "A" & N & ":A" - assuming the left column is "A"

Thank you. I will test your proposed solution with my real data but I would prefer a solution along the lines I suggested.

Thank you, again! I will test both solutions and step through them to make sure they are doing what is intended. I'll set up data for unit testing and let you know what happens.

Neither of those approaches works in my situation. I am attaching a workbook with some typical data.

Note that the values in columns A and D are always in ascending order. The data in columns B and E are in ascending order until their values are greater than 20, after which the values are somewhat random.

I hope this helps. Please let me know if any further explanation is needed,

I don't understand - you suggest that I upload a workbook - I already did (ExcelForum.XLS)

Thanks to everybody for their contributions. I realised, that because of the way the data is set up, I know the row number of the last entry (in columns A and B or columns D and E) and so the following works very nicely

Please Login or Register  to view this content.

Now I need to ask another question about using a named range in defining a chart series ...

Thanks again.