Searching for Cell Content Larger than Find Function's Character Limit

I am trying to search for a paragraph, which is written in a cell over a range of other cells, with the intention of hiding the row that contains it. Since all this needs to be automated, I'm trying to use VBA script like

Set result = searchRange.Find(What:=search, LookIn:=xlValues)
If result Is Nothing Then

Exit Sub

End If
Range(result.MergeArea.Address).EntireRow.Hidden = True

But the paragraph I'm looking for is 300+ characters - larger than the character limit the range.Find method has, so Result comes back as nothing when it should not be.

Does anyone have some idea on how to get around this?

Try something like this...

Please Login or Register  to view this content.

Thanks AlphaFrog, that does help.

But does anyone know if there is a way to do this without having to cut off half of the paragraph?

Originally Posted by spira

Thanks AlphaFrog, that does help.

But does anyone know if there is a way to do this without having to cut off half of the paragraph?

Do you have other similar paragraph's it could erroneously match the first 255 characters?

Originally Posted by AlphaFrog

Do you have other similar paragraph's it could erroneously match the first 255 characters?

I might. The paragraphs are going to change regularly, and some of them get very similar - currently none of them do, but later ones may.

Originally Posted by spira

I might. The paragraphs are going to change regularly, and some of them get very similar - currently none of them do, but later ones may.

Please Login or Register  to view this content.

That is brilliant. Thanks so much :