Hi Sampath ,
This is not an error message ; this is a display alert message , since what you are being informed about is that there is no data meeting the criteria you have set.
Since it is clear that the sought for data does exist on the sheet , there is a mixup as far as the actual character is concerned.
The degree symbol , which resembles a superscript o , can have different Unicode values , some of which are :
00B0 , 00BA , 02DA , 030A , 05AF , 2070
Of course , it can also be a superscripted o !
You need to first verify what it is ; to do this , place the cursor in the cell containing this character , select only that character , and copy it to an unused cell. Suppose this cell now containing the character is AA1 ; in another unused cell , say AA2 , put in the formula =CODE(AA1) , and see what is displayed in AA2.
A superscripted o will show 111 if it is a lower-case o which has been superscripted ; other characters will show 176 , 186 for the characters with Unicode values 00B0 and 00BA.
Where the Unicode value is more than 00FF , the CODE function will return the value 63 , whatever be the hex value.
Thus , the correct way to find such characters in VBA is to copy the character into your code , or use the ChrW function to assign the character to a variable , as in :
charvar = ChrW(&H02DA)
and then look for this variable using the Find method.
Narayan