looping a search function

[pvo2]

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.

[davesexcel]

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.

Good evening,
If your Headings are in row A then this code will loop through row A and when it finds the word "Currency" it will perform an action two rows down:

Please Login or Register  to view this content.