Hi,

I have a range of cells which contain text and I need to be able to find the last cell in that range and delete the cells that I do not require. I need to do this for several ranges within the workbook so obviously i will need to loop the formula.

Does anyone have any ideas?