Problem with Find function. Need to find Exact match

Dear Friends
I have the following code in my script where it finds a memid specified in the sheet.
In my example the memid = "A1"

Please Login or Register  to view this content.

everything is working fine but I have an issue.

I have different IDs in Column "C:C" (Eg: I have A1, A123,A16, etc) and I want to Find only if it is "A1" but in the about case all starting with "A1" is finding. Can you help me to change the code that it Finds exact match of "A1"
Thanks

Look at some of the other arguments Find has.

Perhaps LookAt:=xlWhole.