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)...