Copy cells between two found instances of a different strings

Hi everyone,

I'm trying to write a code that searches for instances of a string within a cell within a range, and then copies everything between that cell and the next instance of a different string.

Sounds confusing, but essentially I have multiple ranges between a cell containing 'Posts:' and a cell containing 'Logged', and these ranges differ in size, but are always contained between these two cells.

This is what I have so far:

Please Login or Register  to view this content.

But I keep getting a 'Compile Error: invalid qualifier', likely because the 'rng1.Row' output is not being treated as an integer.

Is there a way around this?

Thanks so much in advance for all your help.

Hi alansidman,

the line I get the error with is the

Please Login or Register  to view this content.

the first line of the loop. Which leads me to think that it doesn't like the rng2.Row variables.

yep, that was exactly the problem haha

thanks so much for your help millz!!