Copy cells between two found instances of a different strings

[joevan1]

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.

[alansidman]

When you run the code and get the error, what line of code is highlighted when you click on debug?

[millz]

Did not really look into whether your code tackles your problem, but to fix that problem, you can try just removing the Set.

Please Login or Register  to view this content.

You only use Set for object variables, such as Range, Worksheet, etc.

[joevan1]

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.

[joevan1]

yep, that was exactly the problem haha

thanks so much for your help millz!!

[humdingaling]

Set int1 = rng2.Row - rng1.Row

try without SET

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.