Find text between two rows dynamically

[JoTedy]

I want to find a text between two rows. Here are some code snippets:

Please Login or Register  to view this content.

but it gives me a mismatch type error and I don't know how to fix it.

I tried to convert it to string but still didn't help me.

Thank you in advance!

[AlphaFrog]

What line gives the error? Are rowI & rowF dim'ed as type Long ? Is Search dim'ed as type Range?

Can you show the code previous to this?

[JoTedy]

The set Search line gives error.
Yes they are all dim'ed.

Here's the code

Please Login or Register  to view this content.

I tried to use the address instead of row but didn't help me or maybe I didn't know how to write it properly.

[AlphaFrog]

If one of the previous searches for rowI or rowF fail, then the search for the "in between" will error because one of those variables is not defined.

Try putting each subsequent search within the previous search's If-End If code block. Or test the two variable values before searching in between.

[JoTedy]

How do I test the two variables? I used MsgBox to see if both of variables have values and they do.

The problem I think is in this line of code

Please Login or Register  to view this content.

or maybe I didn't make them the right type of data

[AlphaFrog]

Data type Long should be correct for both rowI and rowF.

This range reference should be correct Range("B" & rowI & ":B" & rowF) as long as the values for rowI & rowF are greater than zero and rowI is less than rowF

To test the values...
IF rowI > 0 and rowI < rowF then

Otherwise, can you attach your workbook?

[JoTedy]

I've attached it ( I hope )

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

The "After" range should be within the search range.

[JoTedy]

thank you AlphaFrog

[AlphaFrog]

You're welcome.

You could also omit the After argument.