Cycle through each row in Column A in a for loop for specific text?

Hey,

I need help making a macro to do the following:

1) From A7 to A Last Row cycle through each row looking for for "Summary"
2) When found, it needs to let me know the row number so I can do things like CurrentRow.Offset....
3) To speed the cycle up every time it finds Summary the next Summary will NOT be found in the next 8 rows.

Anyone able to help me with this?

Just find all of them and then iterate the found range.

e.g.

Please Login or Register  to view this content.