Hi, i want to convert my below formula to code, which loop through entire column A and bring me those rows which contain 10-(along with there can be anything).
Code:=INDEX($A$2:$A$401,MATCH("10-*",$A$2:$A$401,0))
urgent help is required
MyValue = Evaluate("=INDEX($A$2:$A$401,MATCH(" & Chr(34) & "10-*" & Chr(34) & ",$A$2:$A$401,0))")