Most Urgent----CONVERT FORMULA INTO CODE

[fari1]

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

=INDEX($A$2:$A$401,MATCH("10-*",$A$2:$A$401,0))

urgent help is required

 

[fari1]

any help

 

[Trevor G]

Can you show a sample of the sheet please

 

[Weaver]

Would it help to filter the data to show cells in the column that begin with "10-"?

Do you need the data to appear elsewhere?

Is column A the only populated column?

 

[fari1]

http://www.mrexcel.com/forum/showthread.php?p=2823926#post2823926

the sample is here, i want the results in sheet2, cant use autofilter in it, its the part of loop

 

[taurean]

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

=INDEX($A$2:$A$401,MATCH("10-*",$A$2:$A$401,0))

urgent help is required

If you want to pass the result of this variable then use:

MyValue = Evaluate("=INDEX($A$2:$A$401,MATCH(" & Chr(34) & "10-*" & Chr(34) & ",$A$2:$A$401,0))")

 

[fari1]

is it a vba code or a formula?

 

[fari1]

i dont have knowldge of vba function, can anyone guide me over this?

 

[taurean]

That is VBA code, where myValue is a variable. I have put code tags around it.

 

[fari1]

i guess it is a function, i dont know how to run a function, will u plz guide