Search a sting in word doc with more than 255 chars

Hi,

Is there any way to create a macro which can search a string with string length more than 255 chars? Also is there any way to know if a word has been replaced in text file, like in a doc i have word "abcdis1234" and if i am searching for a word "is" in the same document, it should show me message as "Not Found". I tried using .MatchWholeWord and then .Find.Found = "true", but still it is showing me message as "Found" which should not happen, but the text is not replaced...

Shankha

You can use InStr to find a substring within string.

InStr doesn't have a limit.

What are you using that does have a 255 character limit?

actually im using this code

with Selection.Find
.Forward = True
.ClearFormatting
.Replacement.ClearFormatting
.MatchCase = True
.MatchWholeWord = True
.Text = Sheet1.Cells(i,2) 'value of i is increasing based on for loop
.Replacement.Text = Sheet1.Cells(i,3)
.Execute Replace:=wdReplaceAll
end with

so here if the length of Sheet1.Cells(i,2) is greater than 255 chars, it s giving error.

So what i tried to do is split the value of Sheet(i,2) into 200 chars each, store 1st 200 in Array1(1), next 200 in Array1(2) and so on. and den comparing the values.... but in this case i cannot use .MatchWholeWord as it will always be false.