Hi,

I'm trying to create a loop which runs a search function to find a particular word, example 'Currency', which is a heading. There are numerous currency headings thruout the spreadsheet and I want find them all to perform certain functions. However, I'm not sure how to stop the search after it's found the last 'currency' heading. Any ideas?

Thank you.