I have a row of percentages: 100%, 200%, 500%, 1000%, 1500%, etc

I'm trying to find the cell that has 500%. I use the code below. factor is a number in a cell of which value is 500%

Set c = rng.Find(factor, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchFormat:=False)

this doesn't work because lookat:=xlWhole. I tried to concatenate factor with a % sign to find it but didn't work either.

I also tried Application.FindFormat.NumberFormat = "0.00%" and set searchformat:=True and didn't work either.

Please help me. I'm so dizzy and my head hurts. Thanks.