Searching in the range

[xzaqus]

Hello-

The .Find function does not work if the range (myRange) contains formulae. But it works, when I copy/paste values in the range. Please suggest how I can make it work without copy/paste

set findText= .Range("myRange").Find(What:=myText, lookat:=xlWhole, MatchCase:=False, SearchFormat:=False)

Thanks.

 

[Fluff]

Try

Set findtext = .Range("myRange").Find(myText, , xlValues, xlWhole, , , False, , False)

 

[xzaqus]

It worked. Thanks.

Try

Set findtext = .Range("myRange").Find(myText, , xlValues, xlWhole, , , False, , False)

 

[Fluff]

You're welcome

 

[xzaqus]

Hi, can you please help with my another problem here https://www.mrexcel.com/forum/excel-questions/1063408-text-number-format-issue.html#post5106696

Thanks again.

You're welcome