Looping through column - do I need two ranges?

[twckfa16]

Hello -

Objective:
1) loop through column pulling out desired data and placing in desired cells
2) if string 'aaaa' is found...loop until string 'page ' is found
3) Pull out page number and place in desired cell
4) Continue in same fashion until another 'page ' is found

Sounds confusing but the attached files should help.

*Note - contents of result file should go with original ranges.xlsm file

Code I'm trying to use:

Please Login or Register  to view this content.

Thank you

[p24leclerc]

At first glance, you seem to have interchanged the row and column in the offset functions.
Offset works like this: Offset(row,column).
Look into that and it might work.