can anyone help y below isn't working.
Adeel
Code: Select all
bb = "adeel1"
sr = Evaluate("Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "),""""))")
sr1 = Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "&""0123456789""))")
Code: Select all
bb = "adeel1"
sr = Evaluate("Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "),""""))")
sr1 = Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "&""0123456789""))")
Code: Select all
sr = Evaluate("Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """),""""))")
sr1 = Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """&""0123456789""))")
Code: Select all
? "Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "),""""))"
Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},adeel1),""))
? "Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """),""""))"
Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},"adeel1"),""))
? "MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & bb & "&""0123456789""))"
MIN(FIND({0,1,2,3,4,5,6,7,8,9},adeel1&"0123456789"))
? "MIN(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """&""0123456789""))"
MIN(FIND({0,1,2,3,4,5,6,7,8,9},"adeel1"&"0123456789"))
Code: Select all
? "Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """),""""))"
Code: Select all
Sub test()
bb = "adeel1"
sr = Evaluate("Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """),""""))")
sr1 = Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """&""0123456789""))")
Stop
End Sub
Code: Select all
bb="adeel1"
? "Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},""" & bb & """),""""))"
Min(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},"adeel1"),""))