Ctr + F (Find) not working

[VBABEGINER]

Dear All,
I have query regarding copy-paste.
Copying data from PDF and paste into my excel book.
My excel book is macro enables, contains some code..
While performing Ctr+f option on Sheet, it is not finding the text, though it is available on sheet...

Could anyone guide me on this please..

 

[VBABEGINER]

If you're sure that text you type

= Yes...

But i didn't get this..

maybe debug.print FndTxt for different iterations

If you're sure that text you type is found but that pasted from PDF is not (in the same ranges) then look closer at:

FndTxt = Range("AA3", Cells(LastRow, LastCol)).Find(What:=zVal.Value, After:=FndTxt, _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
Range("A" & FndTxt.Row).Interior.Color = vbGreen

and maybe debug.print FndTxt for different iterations

 

[sheetspread]

What is that part of the macro returning, errors or just nothing?

 

[VBABEGINER]

it is finding values from the range which is starts from AA3..